Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danipudianto
Contributor
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
sunny_talwar

Try this

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

danipudianto
Contributor
Contributor
Author

Thanks Sunny

It's Work !!

sunny_talwar

Awesome