hi,
I have a pivot table which shows total sales by region. when i filter 2 countries, the grand total column shows total of these 2 countries i.e. 800 (UK + Germany).
My requirement is that in the grand total row of table-1, the total of all the Countries i.e. 1300 should come as given in table 2.
![pivot_table.JPG](/legacyfs/online/99927_pivot_table.JPG)
Thus, my output should be like:
![pivot_table2.JPG](/legacyfs/online/99928_pivot_table2.JPG)
Any suggestions on this are welcome!
TIA,
Karan