How to create row and column total in a pivot table

[#1]

Hi all,

how can I generate the row and column totals in a pivot table like the one hereunder:

	PRODUCT1	PRODUCT2	PRODUCT3	PRODUCT4	PRODUCT5	PRODUCT6	TOTAL
COUNTRY1	100	45	64	77	12	8
COUNTRY2	44	11	12	89	75	63
COUNTRY3	32	45	78	19	22	23
COUNTRY4	21	76	76	18	76	45
COUNTRY5	76	78	90	27	90	54
COUNTRY6	12	99	1	32	91	11
TOTAL

I cannot find the correct way to do it....

Thanks

Francesco

[v_iyyappan]

Hi,

     Goto --> Presentation tab-->Check ---> Show partial sum --> Check --> Subtotal on top or Subtotal on Bottom

Regards,

Iyyappan

[SunilChauhan · Accepted solution]

presentation  check patial sum for two dimension

for first dimension-> total on top and for

second -> value on bottom

hope this helps