Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
skoppe
Contributor II
Contributor II

help needed on percentage in pivot table

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

error loading image

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!

1 Solution

Accepted Solutions
Not applicable

Hi,

see the attached example.

It gives you an idea how it could work.

Good luck!

Rainer

View solution in original post

5 Replies
Not applicable

Hi,

see the attached example.

It gives you an idea how it could work.

Good luck!

Rainer

skoppe
Contributor II
Contributor II
Author

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

Not applicable

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.



Not applicable

Hi

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

jj

Not applicable

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