Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
yogendra_wasaik
Contributor
Contributor

Pivot table total for Year and region for each column

I have a case for pivot table where I have Targets for country in my file. Now I got additionally targets for region year-wise as well as for particular year as well. Now when I am adding Target column in pivot table it is showing me targets against country keeping Region and Year total field blank as per attached screenshot.

yogendra_wasaik_0-1602938924761.png

Now my question is how I can show the targets for Year and Region (these are fixed targets).

E.g. Target for year as below

 2019 = 10,

2020= 30

and target for regions year-wise as below

For 2019:                            For 2020:

MEA12 MEA23
ASPA13 ASPA24
AMER14 AMER25
EUROPE15 EUROPE26

 

 Thanks in advance.

Labels (2)
0 Replies