Calculating the percentage of columns values in totals

[#1]

Hi there,

i have a data set like below on a pivot table

Manager	due day	0-15	16-30	31-45	45+	Total
aa		$27.557	$12.039	$4.978	$7.845	$52.419
bb		$41.924	$32.955	$26.489	$59.119	$160.487
cc		$0	$0	$0	$33.552	$33.552
dd		$196.365	$97.496	$117.485	$251.297	$662.642
ee		$73.342	$6.604	$2.215	$13.000	$95.161
ff		$67.541	$36.390	$35.779	$437.480	$577.190

i'm trying to add a new expression which calculates the percentage of every column in totals as shown in the table below;

	due day	0-15		16-30		31-45		45+		Total
Manager		Amount	Percentage (%)	Amount	Percentage (%)	Amount	Percentage (%)	Amount	Percentage (%)
aa		$27.557	52,57%	$12.039	22,97%	$4.978	9,50%	$7.845	14,97%	$52.419
bb		$41.924	26,12%	$32.955	20,53%	$26.489	16,51%	$59.119	36,84%	$160.487
cc		$0	0,00%	$0	0,00%	$0	0,00%	$33.552	100,00%	$33.552
dd		$196.365	29,63%	$97.496	14,71%	$117.485	17,73%	$251.297	37,92%	$662.642
ee		$73.342	77,07%	$6.604	6,94%	$2.215	2,33%	$13.000	13,66%	$95.161
ff		$67.541	11,70%	$36.390	6,30%	$35.779	6,20%	$437.480	75,79%	$577.190

i need the formula for expression to get this result.

thank you for any idea..

[Anonymous]

You can use the same expression (just copy and past is) and and mark it as "relative"

Qlikview does the math for you 🙂

[#3]

tahnk you,

if it was a straight table then you would be right but unfortunately it is a Pivot table so i cant do it so easy,

any idea for pivot table ??

[Anonymous · Accepted solution]

You are right, I missed that.

Try this:

Sum (Amount) / Sum (Total Amount) * 100

That should work I think.

[#5]

Thank you very much Dennis,

this one works properly.

best regards