Using Value withing Pivot table for calculation - Qlik Community

Hum1 · ‎2019-12-09

Need help with requirement for a project. I have a pivot table that I am trying to use the value populated to do a 2 month ratio on the populated ratio value populated on there. The attachment is what I want to achieve, please advice.

Brett_Bleess · ‎2019-12-17

Have a look at the following Design Blog post, I think it may put you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

If not, here is the base URL for the Design Blog area, so you can search further yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.