Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Rank of Sale state wise and Rank of brand in the sale of state
i have a table which contains the sale of various brands among states
a brand can be sold in various states
now i need to get the rank of sale based on states
and the rank of brand for a state inside the total brand sale for a state
Try this:
Aggr(Rank(Sum({<Brand>}Sale),1,1), state, Brand)
What do you want to see when no Brand is selected?
Attached the Sample data stalwar1
the rank of brand for a state inside the total brand sale for a state
Can you elaborate on this with an example? Is this based on a selection made by the user? I mean I am not sure how to determine the rank and what numbers (based on the sample attached) is the expected output?
hi sunny thanks for the reply
State wise Rank of the Selected Brand
i need to display the rank of sales based on states
this is without user selection
but when user select a particular brand
i need to display the rank of that brand within in the sale of a single state
the first highlight shows the rank of brand for a single state within its own sale
i need to display the user selected brand vice versa on the second highlighted area
thanks in advance
I am still not sure I follow. Lets say you selected Brand1, you can to see its rank across different states?
in state 1 - brand 1 is in 3rd place
in state 2 - brand 1 is in 4th place
in state 3 - brand 1 is in 4th place
in state 4 - brand 1 is in 3rd place
in state 5 - brand 1 is in 3rd place
in state 6- brand 1 is in 2nd place
here im letting the user to select the brand
and i need to show the value vice versa
I think this is what you might be looking for
first 2 expressions are rank and sales across all brands and the last two are rank and sales for Brand1.
Manually updated screen shot
Try this:
Aggr(Rank(Sum({<Brand>}Sale),1,1), state, Brand)
What do you want to see when no Brand is selected?
try this expression:
Rank of sale of state =aggr(rank(sum({$<state={'*'}>}{$<Brand={'*'}>}Sale)),state)
Rank of sale of brand of state ==rank(sum({$<state={'*'}>}{$<Brand={'*'}>}Sale))