Partial sum value in a pivot table

[cmatcovich]

Hi everibody,

I need an expression to calculate a partial percentage (percentage on a subtotal) in a pivot table like this:

Dim1	Dim2	Sum(Value)	SumT	PartPerc
A	AA	1	6	17%
	AB	2	6	33%
	AC	3	6	50%
	Total	6		100%
B	BA	10	60	17%
	BB	20	60	33%
	BC	30	60	50%
	Total	60		100%
Total		66

I tried with this SumT expression:

sum(aggr(sum(Value), Dim1))

but the correct value (6 or 60) is shown only in some cells and not in all of them.

Tanks for any suggestion!

Corrado Matcovich

[#2 · Accepted solution]

Hi,

Try with this:

sum(TOTAL <Dim1> Value)

See the attached.

Regards,

Ricardo

[cmatcovich]

It works (and il was so easy ...)

Thanks a lot.

Regards

Corrado