Trying to create a ranking table

[tom906123]

Hello,

I am trying to create a ranking table based on sum(sales)

I am trying to achieve something like the below then graph the result

Customer	Jan	Feb	Mar	Apr
abc123	1	1	2	3
xyz123	2	3	3	2
defg432	3	2	1	1

I am trying aggr(rank(sum(sales)),[customer],[month])  but no luck

My data looks something like this:

order date	order month	sales	customer
9/12/2018	9	1500	abc123
9/3/2018	9	1000	xyz123
8/4/2018	8	2000	defg432
7/5/2018	7	2500	abc123

Any help would be much appreciated!

Thanks in advance!

[sunny_talwar]

Have you tried this already?

Dimension

Customer

month (Pivoted)

Expression

Rank(Sum(Sales))

[tom906123]

Hi Sunny,

Thanks for your response.

I tried using  the suggested pivot table with the below

1st Dimension: Customer

2nd Dimension: Month

Expression: ranks(sum(sales))

The result shows the below ranking the customer against their self

Customer	month	rank
abc	Jan	2
abc	Feb	4
abc	Mar	5
abc	April	3
abc	May	1
xyz	Jan	1
xyz	Feb	3
xyz	Mar	5
xyz	April	4
xyz	May	2

I would be really interested in see the customers rank against the entire population - any tips?

[sunny_talwar]

Drag the Month dimension to go across and see if that helps