I have built a nice pivot table as shown, and now cracking my head how to get the aggregate for each column.
can you give me a head start on this.

I tried to use the IR aggregating, it it leads to alignment issue.
I thought of scripting into the pivot, just not sure the how and where.
Please help