View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default 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?