Thanks to Rachelle for helping me figure this one out. In Excel 2007, pivot tables have a lot of new options, but some of the old functions seem to be missing.
For example, In the below table … I wanted to change the format so that the MRR and Term Values are stacked in the Pivot Table vs. being displayed side by side. In 2003, you could accomplish this by dragging and dropping the titles. In 2007, dragging and dropping fields no longer works.
In Excel 2007 right click “Values” >select “Move Values to”>select “Move Values to Rows”
Your values will now be stacked like this:
Another option is to use the Field List and drag the values from Columns to Rows:
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
One Comment