help needed on percentage in pivot table

[skoppe]

Is it possible in a pivot table to calculate percentages? See picture for more information:

I would like to add a column Percentage (%) next to the column Spend (€). For each 'Hoofdsegment' I want percentages for 'Preferred' and 'Non-Preferred'. I made an example in the picture.

Spend (€) is based on a key-figure that is the sum of four set analysis statements.

I hope someone can help, thanks in advance!

[#2 · Accepted solution]

Hi,

see the attached example.

It gives you an idea how it could work.

Good luck!

Rainer

[skoppe]

I will look into it, thanks a lot!!!

[#4]

If you can help me I would like to know if there is a way to get the percent share based on the Dimensions collaps.

Example

Now if I collapse " br" my shares come up as 100 % instead of broken by "I4I" .I would like to see share broken out by class and I4I with br Collapsed.

Please let me know.

[#5]

Hi

try Sum(qty)/Sum(total qty) it's the % for each row

jj

[#6]

Thanks for your reply,But That will end up giving 100% for each row .I would like to break out by the last dimension I have .So If I move my dimensions Always share should be calculated by the dimesion available at the end.

Thanks