Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
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
Contributor III
Contributor III

hi,

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

ced_foning
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 : 

Capture.PNG

 

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

 

Thanks

shanemichelon
Partner
Partner

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.