excel - Pivot table output tweaking - specific summary for subset of columns - Stack Overflow

admin管理员组

文章数量:1310466

I would like to create a pivot table with a summary of some sales orders. The sales orders include lists of hardware and software license items. The software licenses have "end dates" as they are licenses for a duration. I would like the finished table to report the numbers of each product sold for each purchase order and, for licenses only the "average" end-date. I have columns set for "hardware" and "software" so that it is easy to tell which product is in which category (product names are somewhat challenging to interpret). Original data and Pivot images attached.

Question: how can I only display the "Average of End Date" summary for the Software category, as it is not relevant to the "Hardware" category - i.e. I don't want the third column in the shown pivot table to display at all

I would like to create a pivot table with a summary of some sales orders. The sales orders include lists of hardware and software license items. The software licenses have "end dates" as they are licenses for a duration. I would like the finished table to report the numbers of each product sold for each purchase order and, for licenses only the "average" end-date. I have columns set for "hardware" and "software" so that it is easy to tell which product is in which category (product names are somewhat challenging to interpret). Original data and Pivot images attached.

Question: how can I only display the "Average of End Date" summary for the Software category, as it is not relevant to the "Hardware" category - i.e. I don't want the third column in the shown pivot table to display at all

• excel
• pivot-table

Share Improve this question Follow edited Feb 3 at 15:57 JetSetJim asked Feb 3 at 11:49 JetSetJimJetSetJim 7811 silver badge1212 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You can't. Every element in the Values well will get assigned its matching column and you can't dynamically suppress it.

Consider

• hiding the whole Excel column after a pivot table refresh
• writing VBA that runs after pivot table refresh to automate hiding the undesired column(s)

本文标签： excelPivot table output tweakingspecific summary for subset of columnsStack Overflow