Relative % not to change upon selection of Dimension-HOW?

[dmohanty]

Hi All,

My requirement is below:

Whenever I would select any dimension, let say Customer 'A' or Region 'R1' (from the QVW attached),

the values of the % Total should not change. It should show the values respective to the Total what was there when no selections were made. However, the chart would show only the selected dimensions, but the Measures should show esactly the same when no selections are made.

Example, If I select Customer 'A', it should show 6.13% and 17.54% (these values are showing when nothing is selected), I would not see 100% and 100%.

Hope I am clear. Please help me on this.

[Gysbert_Wassenaar · Accepted solution]

Try these expressions:

SUM(Sales)/SUM({1}TOTAL Sales)

SUM(Sales)/SUM({1}TOTAL <Region> Sales)

[dmohanty]

Great!!! Exactly the way I wanted.

It was this simple, I could not figure it out.

Kudos and Thanks a Lot for this solution.