Prev: Using shape on a frame????
Next: Compatibility Issue
From: Art on 1 May 2010 09:52
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
From: Roger Govier on 1 May 2010 12:41
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?
 | 
Pages: 1
Prev: Using shape on a frame????
Next: Compatibility Issue