Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator II

show first rank

hi

how can i show the branch with highest sale in label?

1 Solution

Accepted Solutions
Kushal_Chawda

=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))

View solution in original post

7 Replies
susovan
Partner - Specialist
Partner - Specialist

Hi omid,

Try this expression,

Num(Aggr(Rank(Sum({1} "Measure"),4),"Dimension"))

Warm Regards,
Susovan
vikasmahajan

rank(sum(Sales))

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

Dimension = Month

Expressions

FirstSortedValue(Product, -Quantity)

FirstSortedValue(Quantity, -Quantity)

  

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
omid5ive
Creator II
Creator II
Author

i used this:

=num(Aggr(Rank(Sum({1} L_COUNT),4),PROVIENCE_NAME))

but it doesnt show any thing

Kushal_Chawda

=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))

omid5ive
Creator II
Creator II
Author

Tanks Kushal

Kushal_Chawda

Welcome