Need help on Pivot table

Copper Contributor

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

@Lawrence2200 

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