Partial sum in a pivot table

[#1]

Hi,

Below is my pivot table, I have total in column for each SITE per TYPE I would like to also have my total in row for each REG per TYPE, this means to have the last column.splitted in 2 columns TYPE1 and TYPE2

Is it possible ? (file attached)

[Siva_Sankar]

Hi,  Find the attachement. hope it helps.  Regards. Siva Sankar

[#3]

Thanks but I don't want to change the pivot, I want to keep my total per "Type" for each "Site" and add an other total per "Type" dor each "Reg" like this

[#4]

Hi,

I have attached the document, Hope it Helps.

Regards,

Kabilan K.

[#5]

Yes like this I have my total per "type" but it doesn't look like the presentation I really wanted