Percentage relative to Total?

[dmohanty]

Hi All,

The requirement is simple, but I am not getting the desired results. Please help.

I have to show the Total Sales or Count of Orders per each Region. That's easy.

Along with that I need to show the Percentage of Sales/ Count comapred to Total Sales or Total Count.

How to achieve this?

[arsal_90]

Can u elaborate your requirement in excel. Mention the columns and dumy data in excel and also mention the desired result what u want

[#3]

Try this:-

sum(Amount)/sum(TOTAL Amount)

[MK_QSL · Accepted solution]

Please check enclosed file.

There are three different %TOTAL given.

Choose your desired one...

[Anonymous]

Hi,

check this.

The expression is on the caption bar.

[#6]

Hi,

if you work with straigt table you can use the option Relative.

For pivot table you have to use the total function in your expression:

sum(Sales)/sum(total Sales)

sum(Count)/sum(total Count)

[dmohanty]

Thank you very much Manish, for this great help.

[dmohanty]

Hi,

I am reposting in this thread as a bit enhancement required. My requirement is below:

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

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, bu 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 showin when nothing is selected), I would not see 100% and 100%.

Please help me on this.

[MK_QSL]

Can you please create a new thread please? so that other member can also answer.