Is there a way to move the Column Total to the beginning of the report? Excel
places it at the end of the report as default. I tried to meve as other
fields (just with the cursor) but didn't work.

Thanks a lot for the help!

Hi Andy

No, you can not move it.
The only way around, is to create a copy of the values to a row at the top
of your table.
Use the GetPivotData function to select the values required.

--
Regards
Roger Govier

"Andy" wrote in message
...
Is there a way to move the Column Total to the beginning of the report?
Excel
places it at the end of the report as default. I tried to meve as other
fields (just with the cursor) but didn't work.

Thanks a lot for the help!

There's a workaround described here that lets you display a grand total
in the first row of the pivot table, instead of at the bottom.
I don't know of any workaround to display a grand total in the first
column, instead of at the far right.

http://www.contextures.com/xlPivot13.html

Andy wrote:
Is there a way to move the Column Total to the beginning of the report? Excel
places it at the end of the report as default. I tried to meve as other
fields (just with the cursor) but didn't work.

Thanks a lot for the help!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com