Hopefully someone can help me!
I have a table with business data such as units sold, revenue etc. entered by date (1/1/14, 1/2/14...) for 4 different business units. I have this data summarized in a pivot table. The pivot table is set up with the date filter as a row label. I would like to have a consolidated report on another worksheet with a drop down menu being used to control the date filter on my pivot table. The following items would be on the drop down: Yesterday, Month to Date, Quarter 1, Quarter 2, Quarter 3, Quarter 4 and Year to Date. Any suggestions on how I could accomplish this? Sorry for being so green on this topic. Thanks.
I have a table with business data such as units sold, revenue etc. entered by date (1/1/14, 1/2/14...) for 4 different business units. I have this data summarized in a pivot table. The pivot table is set up with the date filter as a row label. I would like to have a consolidated report on another worksheet with a drop down menu being used to control the date filter on my pivot table. The following items would be on the drop down: Yesterday, Month to Date, Quarter 1, Quarter 2, Quarter 3, Quarter 4 and Year to Date. Any suggestions on how I could accomplish this? Sorry for being so green on this topic. Thanks.