Display of totals in Pivot Table Columns
 

Hi,

A pivot table with sales amount in the data field has two column
fields: Salesman and Area. The table displays the columnar data as
follows: Salesman1, North, South, East, West,Total for Salesman1,
Salesman2, North, South, East, West, Total for Salesman2, Salesman3,
North.. and so on.The final column is Grand Total.

What I need is this:
Salesman1, North, South, East, West, Salesman2, North, South, East,
West,...........Total for North, Total for South, Total for East,
Total for West, Grand Total

How can I do this?

Thanks in advance for the help.

Regards,
Raj