Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank In Pivot table with multiple dimensions

Hello all,

I am trying to create a pivot table, how to showing the sales by rank based on all dimensions.

9 Replies
sunilkumarqv
Specialist II
Specialist II

these because of multiple dimensions

use only  only One Dimension - Customer ID then add Country in your Expression

it solve your problem

let me know if anything has to be corrected 

Not applicable
Author

Hi Sunil Kumar..

Thanks for giving reply..No But i want to include all the dimension .that is the original requirement..

So can u please give any other information regarding this...

sunilkumarqv
Specialist II
Specialist II

Go to Presentation tab-

check -Always fully Expanded option

its_anandrjs

Hi,

As i understand your expression

=Rank(TOTAL Aggr((Sum(Sales)), Country, Customer ID, Customer Name),0,1)


works fine in pivot also please clear your requirement it is some thing like


Country

Customer ID

Customer Name

Sales

Rank

France

Customer ID1

Customer 1

100

2

France

Customer ID2

Customer 2

50

3

France

Customer ID3

Customer 3

300

1

Germany

Customer ID4

Customer 4

400

1

Germany

Customer ID5

Customer 5

200

2

when selecting country

Hope this helps

Thanks & Regards

Not applicable
Author

hi anand this can be done this with this simple Formula

Aggr(Rank(Sum(Sales)),Country,[Customer Name])

its_anandrjs

Hi,

If this is your requirement do with this

=aggr(num(rank(sum(Sales),1)),Country,CustomerID)

Hope this helps

Thanks & Regards

Not applicable
Author

hi anji try this

this exactly giving output

Aggr(Rank(Sum(Sales)),[Customer Name])

i have attached Sample Application

Not applicable
Author

Hi Anand,

Hi Gysbert,

Here i need just one record whose rank is "2" either PA001 or TA001,How can i achieve it ??

Capture.PNG