Pivot Table Total

[upaliwije]

I have a pivot Table as follows

Region     Product       Sales

NORTH       A              100

                  B              150

                  C                50

TOTAL                        300

SOUTH       A               200

                  C               300

                  D               100

TOTAL                         600

G.TOTAL                     900

How can I show  Grand total of the Products just above the G.Total  in the same pivot table as follows

Region     Product       Sales

NORTH       A              100

                  B              150

                  C                50

TOTAL                        300

SOUTH       A               200

                  C               300

                  D               100

TOTAL                         600

                 A               300

                   B               150

                   C               350

                   D               100

G.TOTAL                     900 

Is there method show the above products total highlighted in red the one and the same pivot table. If so pls let me know how ?

[swapnil_kumbhar]

hI Upali,

You can get the Product wise & Region wise total by using some other way in Pivot Table.

Please find attached file.

Regards,

Swapnil

[upaliwije]

Thanks

But I want it in the format I have shown.