Pivot table subtotal (excel 2007)

[poiu]

Hello,

I have the pivot table below which has subtotals for each period. But the subtotal appears above the relevent data, not below. Please could you tell me how to move subtotals below the relevent data?

Thanks,

Poiu

Row Labels	Sum of Amount
Period 1	746
P700000</SPAN>	345</SPAN>
P700001</SPAN>	45</SPAN>
P700002</SPAN>	356</SPAN>
Period 2	3836
P700000</SPAN>	35</SPAN>
P700001</SPAN>	3567</SPAN>
P700002</SPAN>	234</SPAN>
Period 3	1087
P700000</SPAN>	85</SPAN>
P700001</SPAN>	246</SPAN>
P700002</SPAN>	756</SPAN>
Grand Total	5669

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

 

[jaybee3]

It should be found here:

PivotTable Tools > Design > Subtotals > Show All Subtotals At Bottom of Group

 

[poiu]

Great, thanks!