# Rank Clarification

**URL:** <https://community.amazonquick.com/t/rank-clarification/26544>\
**Category:** Q&A\
**Tags:** error, developer, quick-sight\
**Created:** [February 28, 2024, 6:55am UTC](https://community.amazonquick.com/t/rank-clarification/26544 "2024-02-28T06:55:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinodkumarb](https://avatars.discourse-cdn.com/v4/letter/v/c67d28/32.png) [@vinodkumarb](https://community.amazonquick.com/u/vinodkumarb)\
**Post date:** [February 28, 2024, 6:55am UTC](https://community.amazonquick.com/t/rank-clarification/26544/1 "2024-02-28T06:55:28Z")

</div>

In my report i am using densrank() like

denseRank([{growth percentage} DESC])

 ![Screenshot 2024-02-28 122136](https://d1wl4jav5dp96l.cloudfront.net/original/3X/5/9/59384b44a5bdbbffad53602bb88580d266f5edfd.png)

for above screenshot

jabra has got 1st rank  
Acer has got 2nd rank

is it correct way or not can any one Explain on the same

Thanks  
vinod kumar

---

<div class="post-metadata">

**Author:** ![robert.eibers](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/robert.eibers/32/17657_2.png) [@robert.eibers](https://community.amazonquick.com/u/robert.eibers)\
**Post date:** [February 28, 2024, 8:03am UTC](https://community.amazonquick.com/t/rank-clarification/26544/2 "2024-02-28T08:03:58Z")

</div>

Hey @vinodkumarb ,  
it seems like they all should be Rank 1. Maybe you could check if Jabre actually has a minimal growth, try to check the decimal behind current\_month. So growth percentage is actually something like 0.00123 like that.

BR  
Robert

---

<div class="post-metadata">

**Author:** ![vinodkumarb](https://avatars.discourse-cdn.com/v4/letter/v/c67d28/32.png) [@vinodkumarb](https://community.amazonquick.com/u/vinodkumarb)\
**Post date:** [February 28, 2024, 8:36am UTC](https://community.amazonquick.com/t/rank-clarification/26544/3 "2024-02-28T08:36:01Z")

</div>

Hi @robert.eibers

thanks for quicks reply

in the table i have mention current month and last month values also

 ![Screenshot 2024-02-28 140455](https://d1wl4jav5dp96l.cloudfront.net/original/3X/c/5/c5b6c31aad4d0424ea4a584e1c9196ce3200f092.png)

please provide me the solution

thanks  
B Vinod kumar

---

<div class="post-metadata">

**Author:** ![robert.eibers](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/robert.eibers/32/17657_2.png) [@robert.eibers](https://community.amazonquick.com/u/robert.eibers)\
**Post date:** [February 29, 2024, 7:57am UTC](https://community.amazonquick.com/t/rank-clarification/26544/4 "2024-02-29T07:57:56Z")

</div>

Hey,

I don’t think the other measures have an impact but dimensions can have. You could try to partition by Brand but normally that should not be necessary.

BR  
Robert