Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - move Totals column
I have a pivot table with many columns, so the row totals are displayed far
to the right. Is there a way to move the Totals column so that it is the second column after the row labels? -- Art |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - move Totals column
Hi Art
No there is no way to do it within the PT. You could insert a column before your PT (insert column A) and put a formula there to "grab" the Total from the far right of the PT. You will need to use the GetPIvotData function. It the first row of column A where you want a total to appear, enter =Getpivotdata( and then point to the first cell that has the dat you want, and then type the colsing parenthesis. Part of the formula that gets created, will refer to the Row label of that first row, enclosed within double quotes. Replace the whole of that (quotes as well) with the cell reference of that Row label e.g. B4 You can then copy the formula down as far as you require. -- Regards Roger Govier Art wrote: I have a pivot table with many columns, so the row totals are displayed far to the right. Is there a way to move the Totals column so that it is the second column after the row labels? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Excel2007: How to move Column Totals to the beginning? | Excel Discussion (Misc queries) | |||
How do I move the Pivot Table totals from the bottom row to the t. | Excel Discussion (Misc queries) | |||
Pivot Table Column Totals | Excel Worksheet Functions | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
move column total in pivot table to begining | Excel Discussion (Misc queries) |