Pivot Excel2007: How to move Column Totals to the beginning?
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!
|