Pivot Table totals

[Klb1503]

Hi,

I have a pivot table that is showing countries along the top and sales divisions down the side. I want to show all the sales for each country for this month and then a total and then all the sales for each country for last month and then a total but the pivot table is putting the totals for both current and prior month at the end. is there a way to move the totals after the data so it shows current month/current month total and prior month/prior month total?

Thanks
Karen

Current Month______________________Prior Month______________Current month total___Prior month total
Country.....UK....Spain...Norway..France...UK....Spain...Norway..France......Total..........................Total
Division_1..20......23.......24.......26.........25......28......30.........20............93............................103

 

[jarjarbingie]

Hi,

I have a pivot table that is showing countries along the top and sales divisions down the side. I want to show all the sales for each country for this month and then a total and then all the sales for each country for last month and then a total but the pivot table is putting the totals for both current and prior month at the end. is there a way to move the totals after the data so it shows current month/current month total and prior month/prior month total?

Thanks
Karen

Current Month______________________Prior Month______________Current month total___Prior month total
Country.....UK....Spain...Norway..France...UK....Spain...Norway..France......Total..........................Total
Division_1..20......23.......24.......26.........25......28......30.........20............93............................103

based on your description, I think your data is in a crosstab format, meaning, in the raw data, you have a column for Current Month Sales and another column for Prior Month Sales..

with your required pivot table layout, you would need to restructure the data such that, in a single column, let's call it, Month Type, you would have the values "Current" or "Prior" and then another column for the actual Sales numbers..

this way, you would be able to drag the field Month Type into columns and you can have the subtotal right next to the values..