row total in pivot table with calculated dimensions

[#1]

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.

[#2 · Accepted solution]

only needed aggregation over the first two dimensions ...