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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KCK
Contributor
Contributor

Insert Calculated Field in Pivot Table

I have some sales data grouped according to route category, but then i would like the calculated the % 202309 compared to that of 201808 and 201909. Below is the screenshot of the pivot table in QS app. 

E.g. Results should show as something like this.

  201809 201909 202309
Canada 50% 20% 100%
Chinese Mainland 40% 30% 100%
Europe 20% 80% 100%

KCK_2-1691377141990.png

 

Labels (1)
0 Replies