Sample data in a packaged workbook, please. Thanks,
I'm using superstore sales and attached report has three filters Year, Month and Week.
And on the columns shelf i have a date hierarchy. (custom hierarchy).
Now when i choose "All" as a value in the year filter, the chart should be broken down by years,
when a particular Year is choses, the report should display the chart broken down by months
Note: I dont want to use the drill functionality, this should happen based on the filter values.