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

[Clever_Anjos]

Please, find attached

[#3]

Thank you for your help Clever, I don't understand why it doesn't work with my file...

I have this result.

Regards

Bérengère

[Clever_Anjos]

Please check if "Supress zero values" is checked under Presentation Tab

[#5]

Yes, it's checked in Presentation tab and in Dimension tab

Regards

Bérengère

[Clever_Anjos]

When you open my qvw is not working?

Which version are you using?

[#7]

Even with your qvw, it doesn't work. I use 11.2 version. Is-it the same as yours ? 

[Clever_Anjos]

Yes...

11.20

Please see how it works when "Toto" is selectect or not

[rubenmarin]

Mine is 11.2 SR6 and Clever's solution works fine.

[#10]

Clever,

Your version is 11.2 SR6 like Ruben ? Because I use 11.2 SR3

[Clever_Anjos]

11.20 SR8