Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arranging Pivot Table data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arranging row titles in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot tables - arranging data to appear in columns for each row it | Excel Worksheet Functions | |||
arranging columns in pivot table | Excel Discussion (Misc queries) | |||
ARRANGING DATA IN PIVOT TABLES | Excel Worksheet Functions | |||
Arranging data for Pivot table creation????? | Excel Programming |