Rank in pivot table

[#1]

Hi everybody,

I have a pivot table with 2 dimensions, Quarter and Area and some expressions.

This pivot table is shown only when the user select only one company because there are some expressions about the market (= all companies) and some others about the selected company.

My pivot table is like this (dimensions in bold and expressions in italic)

Area                                                              Q1       Q2       Q3       Q4

North America      

  Sales Market                                              100     120     110     140

  Sales Selected Company                            30        40        25        50

  Rank Company                                            2          2          2          2                     

South America      

  Sales Market                                              110     125     130     140

  Sales Selected Company                            35        30        20        40

  Rank Company                                            1          1          1          1

Among my expressions, I need to calculate the rank but if I use this expression : =rank(sum({<$(CTXT_COMPANY),$(CTXT_REBATES)>}SALES)), the rank calculated is 1 or 2 because it’s calculated for only the selected company among Area.

I would like calculate the rank of the selected company among all companies, by area.

Could you help me for this ?

Thank you

Regards

Bérengère

[#2]

OK, maybe it's the reason why it doesn't work with my qvw...

Anyway, thank you for your responses.

Regards

Bérengère