How to display conditional totals as a separate row at the bottom of the pivot table ?

[bob654321]

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.

[uacg0009]

Hi,

could you please show your origin data model?

so I can try to find a way to solve this.

Aiolos Zhao