Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table: showing COLUMN summaries for some, not all, COLUMN fields.
Hi,
My pivot table has five COLUMN fields, one PAGE field, and three ROW fields. I want to output a report from this pivot table. For some of the column pivot items, I want to hide the detail and just output the subtotals, and for other columns pivot items I want to show the detail and NOT the subtotals. For some columns I want to show items with no data and for others I don't. To try to illustrate this, three of the column fields are (in order of listing on the Pivot Table): 1. ApplicationOutcomeStatus 2. ApplicationStatus 3. ApplicationOfferResponse For ApplicationOutcomeStatus, there are the following values: Reject Offer Waitlist Pending I want the TOTAL of Reject and WAITLIST (ie hide the details). If the PageItem has no data, I still want to see these columns. For those records with an ApplicationOutcomeStatus ="OFFER". I need some details on the ApplicationStatus: I want the total of only those records with an ApplicationStatus="PENDING" and AppOfferResponse="COMPLETE". Again, if the PageItem changes and there is no data, I need to see these columns. My problem is that while I can fix the columns when looking at one Page Item, changing the PageItem hide the empty columns. I also want to be able to configure the visible/hidden details. Am I right in thinking that the only way to do this is with pretty complex VBA? Thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table multiple column fields | Excel Discussion (Misc queries) | |||
Pivot Table Options 'Fields per column' | Excel Discussion (Misc queries) | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
refresh of pivot table clears fields (column headers) | Excel Discussion (Misc queries) | |||
How to get data from pivot table with multiple column fields? | Excel Programming |