Pivot table issue

[#1]

Hello

I have a Piovt table with 5 dimensions and on expression.for this i want to find the total sales .and for that total sales i want to find the rank also.this work i was done in Straight table.but when it is comes to pivot table The Rank is comming but when i use  Collaspe all(-) the Rank also will change..i am getting "N"  for all the sales. when i use expand(+) Then rank is comming..

here is the sample data..

in this when i Group Collaspe all(-) :name field ,it will display rank 1

  when i Group Collaspe all(-) :f.name field ,it will display rank 2

  when i Group Collaspe all(-) :name field ,it will display rank 3

So can any one  please help me out in this issue

[jonathandienst]

Hi

Your posted sample file appears to be empty.

Jonathan

[#3]

Please find the atachment