Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
Have you tried with a total column (enable Partial sum in presentation tab)?
Just add one more expression as Actual+Norm and give label name what you want.
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
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
Have you tried with a total column (enable Partial sum in presentation tab)?