Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get sum of all dynamic column values in a separate field

Hello All,

I have created Pivot Table Report. Please find the attached screen sheet. If I select start date and end date then the report will display the sum of Actual and norm values for each week by displaying weekstart date on the top.

I also want to add one more column which shows sum of Actual and Norm values for all weeks that are displayed on the report.

Helpful answer would be appreciated.

Thanks in Advance!!!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you tried with a total column (enable Partial sum in presentation tab)?

View solution in original post

4 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Just add one more expression as Actual+Norm and give label name what you want.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use the expression for actual+normal like this

     =Column(2)+Column(3)

     Assuming that your actual is 2nd expression(so i used Column(2)) and norm is 3rd expression(so Column(3)).

Hope it helps

Celambarasan

Not applicable
Author

Thanks for you reply...You would have understood in different way...Actually i want sum of actual values for all weeks that are displayed on the report in one column and sum of norm values for all weeks that are displayed on the report in different column

swuehl
MVP
MVP

Have you tried with a total column (enable Partial sum in presentation tab)?