Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
ced_foning
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 : 

Capture1.PNG

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 

Capture.PNG

 

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

Thanks for your help

@Taoufik123 

Labels (2)
3 Replies
G3S
Creator
Creator

hi,

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

ced_foning
Contributor III
Contributor III
Author

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

Capture.PNG

 

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

 

Thanks

shanemichelon
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.