Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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