Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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))

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