Pivot Table - move Totals column

A

Art

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?
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top