Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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