very importent in pivot table

[#1]

Hi Friends

I have a scenario like...i have to find the rank for particular sales.in this i have 4 dimsions are there..

so i resolve that issue .but when it is converted to pivot table the rank is not cumming..it is showing null value..

Can any body help me...

[#2]

Can you share a sample app?

[#3]

Hi Friends

I have a scenario like...i have to find the rank for particular sales.in this i have 4 dimsions are there..

so i resolve that issue .but when it is converted to pivot table the rank is not cumming..it is showing null value..

Can any body help me...

i done this is in the barchart..so when it is converted to pivot table the rank showing null.

Company               Salesman              Count of Sales         Rank

ABC                      GH                        23                           1 

ABC                      TR                         21                           2

ABC                      JP                         21                           3

DEF                      BN                        54                            4

DEF                      VC                        32                            5

DEF                      OK                        32                            6

Thanks