Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table (same level hierarchy fields)
I understand that Pivot Tables aggregate data based on hierarchy's--however,
is there any way (perhaps using vba) to modify a Pivot Table to display 2 or more fields on the same line if the fields are on the same hierarchy level? I often utilize Pivot Tables by showing sales data by item and filter this data using fields in the page area. I would love to be able to display item number and description on the same line; however, since it functions as a hierarchy it automatically displays them on 2 lines. I'm new to vba, but I know vba allows you to do things that are otherwise impossible. Can vba allow you to do what I'm asking? Below I've listed an example of how it is currently displayed, and below it, how I'd like it to display. Item Description Sales 22222 2 (what it does) Widget --------------------------------------------------------------------------------- Item Description Sales 22222 Widget 2 (what I'd like) Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Pivot table hierarchy question | Excel Worksheet Functions | |||
Pivot table totals in low levels of hierarchy | Excel Discussion (Misc queries) | |||
How to filter only the first level in the hierarchy | Excel Discussion (Misc queries) | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) |