Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

How to calculate total for years in pivot table.

Hi Everyone,

I have to add column Total for 2019 and 2018(like shown in table below), Not sure how this is done in the below scenario -

Name

Calculated Fields

2019 Total

2018 Total

MAR-2019

FEB-2019

Jan-2019

Dec-2018

Nov-2018

Aug-2018

Mar-2018

Jan-2018

Name1

Internal

2

10

1

1

-

2

2

2

2

2

 

External

4

8

2

2

-

4

4

-

-

-

 

Legal

6

15

3

-

3

5

5

5

-

-

 

Item

1

2

-

1

-

2

-

-

-

-

Name2

Internal

 

 

 

 

 

 

 

 

 

 

 

External

 

 

 

 

 

 

 

 

 

 

 

Legal

 

 

 

 

 

 

 

 

 

 

 

Item

 

 

 

 

 

 

 

 

 

 

 

I want to create for such scenario with new  calculate column, Could someone please advise the best way.

 

Thanks in Advance! 

0 Replies