Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create row and column total in a pivot table

Hi all,

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

                 PRODUCT1PRODUCT2 PRODUCT3 PRODUCT4PRODUCT5PRODUCT6 TOTAL
COUNTRY1100456477128
COUNTRY2441112897563
COUNTRY3324578192223
COUNTRY4217676187645
COUNTRY5767890279054
COUNTRY612991329111
TOTAL






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

Thanks

Francesco

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

presentation  check patial sum for two dimension

for first dimension-> total on top and for

second -> value on bottom

hope this helps

Sunil Chauhan

View solution in original post

2 Replies
v_iyyappan
Specialist
Specialist

Hi,

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

Regards,

Iyyappan

SunilChauhan
Champion
Champion

presentation  check patial sum for two dimension

for first dimension-> total on top and for

second -> value on bottom

hope this helps

Sunil Chauhan