PC Review


Reply
Thread Tools Rate Thread

Arranging Pivot Table data

 
 
=?Utf-8?B?SkM=?=
Guest
Posts: n/a
 
      23rd Oct 2007
I've got a basic pivot table set up as follows:

Year PER 1
Sales Rep1 2006 Units 69,498
2006 Gross $ 1,241,632
2007 Units 76,579
2007 Gross $ 1,262,005
2008 Units 136,081
2008 Gross $ 2,133,336

Above is how the pivot table sets it up...with Period 1 as my "Data" and the
Sales Rep Name and Year set up as my "Row" (According to the "Pivot Table
Wizard"). Ho do I get the pivot table to arrange my "year" so i can see the
Units in year order, then then the Gross $ lined up...
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table - arranging data appropriately before performing pivot =?Utf-8?B?QmVuMTIz?= Microsoft Excel Discussion 0 11th Apr 2006 03:42 PM
Arranging data for Pivot table creation????? jacef Microsoft Excel Programming 1 20th Sep 2004 08:49 PM
Problems arranging data for Pivot table jacef Microsoft Excel Misc 1 20th Sep 2004 08:49 PM
Help needed arranging data for a pivot table jacef Microsoft Excel Charting 1 20th Sep 2004 08:47 PM
arranging data - Pivot Table? Susie Microsoft Excel Misc 2 22nd Apr 2004 12:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:29 PM.