How to display conditional totals as a separate row at the bottom of the pivot table ?
So the report template should look like this. I was able to create the cross tab report using pivot table from the chart options. I need to add 'Total' Column at the bottom separately which is equal to Sum of the values that are associated with Company3 and same thing applies for Company4. How can I do this ? I've also attached the excel file.