Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

danipudianto
New Contributor

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

Dear All,

I need yours help

Please see this picture :

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

a.jpg

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

3 Replies

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

Try this

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

Highlighted
danipudianto
New Contributor

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

Thanks Sunny

It's Work !!

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

Awesome