LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Pivot Excel2007: How to move Column Totals to the beginning?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to move - from end of number to beginning Giggly4g Excel Discussion (Misc queries) 6 April 2nd 08 05:28 AM
How do I move the Pivot Table totals from the bottom row to the t. Bill Excel Discussion (Misc queries) 0 October 4th 07 09:28 PM
Pivot Table Column Totals Cecilia Excel Worksheet Functions 2 May 16th 07 03:09 AM
shortcut key to move to beginning of new row bob engler Excel Worksheet Functions 2 April 23rd 06 08:01 PM
need enter key to move to the next column beginning j pantozzi Excel Worksheet Functions 2 December 5th 05 04:57 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"