Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Tables multiple data fields
I'm new to pivot tables and am trying to find ways to use them.
Is it possible to have multiple fields of "Data" appearing horizontally so it is easy to compare? I'm thinking of data that includes dollars, percentages, and sales units. When these items appear vertically and sum, they are meaningless and hard to analyze. |
#2
|
|||
|
|||
Yes, and if the sums at the bottom or right are meaningless then simply right
click on the table, choose Table Options and untick 'Grand Totals for Rows' or '....for Columns' You can drag multiple fields into the data area and as you say they will then appear vertically underneath a single grey header marked 'Data'. then just grab that cell marked 'Data' and drag it into the COLUMN FIELDS area and they will all appear horizontally. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Excel GuRu" <Excel wrote in message ... I'm new to pivot tables and am trying to find ways to use them. Is it possible to have multiple fields of "Data" appearing horizontally so it is easy to compare? I'm thinking of data that includes dollars, percentages, and sales units. When these items appear vertically and sum, they are meaningless and hard to analyze. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004 |
#3
|
|||
|
|||
If you drag the Data button onto the cell that contains the word Total,
the data fields will be arranged horizontally. There's a picture he http://www.contextures.com/xlPivot02.html Excel GuRu wrote: I'm new to pivot tables and am trying to find ways to use them. Is it possible to have multiple fields of "Data" appearing horizontally so it is easy to compare? I'm thinking of data that includes dollars, percentages, and sales units. When these items appear vertically and sum, they are meaningless and hard to analyze. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables filtering data | Excel Discussion (Misc queries) | |||
Sorting data in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
merging multiple pivot tables | Excel Worksheet Functions |