Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table totals in low levels of hierarchy
Hi,
Say I have a pivot table with a "Month" and "Date" fields, and a measurement named "Sales", which is aggregated PER MONTH. When I add "Month", "Date" and then "Sales", the data (sales) for each date is like the one of the whole month (since it's aggregated for the month only). Some of our clients find it confusing. Is there a way to hide the data for the date in such a case? Thanks, Nir. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table For Running Inventory Levels | Excel Discussion (Misc queries) | |||
Totals in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Row Totals | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Pivot Table Totals | Excel Discussion (Misc queries) |