Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table hierarchy question
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 totals in low levels of hierarchy | Excel Discussion (Misc queries) | |||
Pivot Table question | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions |