Pivot table problem...

[#1]

Hi Friends

I have a scenario like...i have to find the rank for  sales..

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

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

Can any body help me...

Thanks

[#2]

Hi Anji,

I think you are calculating Count(Sales) as your header suggest:'Count Of Sales'..

Instead of that calculate Sum(Sales) ,

[Gysbert_Wassenaar]

Try rank(total sum([Count of Sales]))

[#4]

Hi friend

I am not getting ...

[Gysbert_Wassenaar]

That makes two of us. I'm not getting you either. Can you post the document you're working on, including the bar chart? Perhaps that makes it clear what you want.

[sunilkumarqv]

try like these

On Expression tab

add one more expression as

aggr(rank( sum( Count of sales) ), Company ,Salesman ))

OR

aggr(rank( count( Sales) ), Company ,Salesman ))