Need help on Pivot table

Occasional Visitor

Imagine I have a pivot table showing months by the column, how do i show total country sales volume and total country sales amount in each rows for each country before the next country?

Thanks.. excel noob

1 Reply


To achieve this, drag the Values in the Rows area. Refer to the screenshot below...

Step1 Values.jpg


It will look like below in the end.

Step2 Values.jpg