How to get sum column (each column) in pivot table ?

[danipudianto]

Dear All,

I need yours help

Please see this picture :

(Sorry, I think it's easier to talk through pictures)

Value 3 is sum value column day 1,2,5,6,7 and 8

not value from 500/600 = 0.83

Can I get value =3

Be Regards

Dani Pudianto

[sunny_talwar]

Try this

Sum(Aggr(sum(plan)/sum(cap*wd), subinv, day))

[danipudianto]

Thanks Sunny

It's Work !!

[sunny_talwar]

Awesome