Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a pivot table to put data after each row/column.
I have a nice pivot table with data set up but it is in this format:
PERS DTYPE Count of PERS Pct of PERS Count of DTYPE Pct of DTYPE ACE ZD 5 15% 3 10% For the boss I need it to look like this format: PERS Count of PERS Pct of PERS DTYPE Count of DTYPE Pct of DTYPE ACE 5 15% ZD 3 10% I am on a time limit so if you could tell me how to format a pivot table this way it would save me. Thanks, Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Table Source Data | New Users to Excel | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
pivot table in data source order | Excel Discussion (Misc queries) |