row total in pivot table with calculated dimensions

Fri, 07 Jan 2011 07:37:01 GMT

So I've been fighting with this for a day, probably very simple but ...

I have a pivot table with several calculated dimensions such as end date and other dimensions which are formatted in the chart

I use a formula to calculated the man days which is set as an expression as =$(=FORMULA) which is taken from table that is loaded inline (below).

if(mod(count(UUID),8) = 0,num(count(UUID)/8,'#.##0'),if(subfield(num(count(UUID)/8,'#.##0,000'),',',2) <= 375,subfield(num(count(UUID)/8,'#.##0,000'),',',1),if(subfield(num(count(UUID)/8,'#.##0,000'),',',2) > 375 and subfield(num(count(UUID)/8,'#.##0,000'),',',2) <= 875,subfield(num(count(UUID)/8,'#.##0,000'),',',1)+.5,if(subfield(num(count(UUID)/8,'#.##0,000'),',',2) > 875,subfield(num(count(UUID)/8,'#.##0,000'),',',1)+1))))

What I'm trying to add is another column (calculated dimension) which is called consumed days or the sum of each row.

I've tried sum(aggr($(=FORMULA),dim1,dim2,dim3,...) reverse this to aggr(sum(... etc.

My question really is how to achieve a sum of each row in the dimensions?

Thanks for any help.

row total in pivot table with calculated dimensions

Tue, 11 Jan 2011 14:53:59 GMT

only needed aggregation over the first two dimensions ...

topic row total in pivot table with calculated dimensions in QlikView

row total in pivot table with calculated dimensions

row total in pivot table with calculated dimensions