Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Add column total per date pivot table

Hello, i have an issue. 

I have a pivot table in the following picture : 


i want to have a column total per date i.e for exemple, after the last column (TFG IP) of date 27/12/2019, i want to have a column total which calculates all amount for that date. 

this should be done for each date in the pivot table. 


Here is an illustration 



I've attached an excel file, which has the column in yellow that i wish to add.

Thanks for your help


Labels (2)
3 Replies
Creator III
Creator III


There should be a 'Show Total' option for the Date dimension in the column section. 

Contributor III
Contributor III

Hi @G3S , thanks for your reply. 
this is what it does when the "show total" option is activated for the date dimension : 



This is not what i want. I want a total for each date. 



Partner - Creator II
Partner - Creator II

I think you want the total on the 'Reporting Line' dimension not the Date dimension.  The total is for the dimension you are setting it on.  Ie, if you select to show the total for 'Date', you will get a total of all the dates.  if you select total on 'reporting Line', you will get the total of all the various reporting lines for each date.