Hey Guru's,
Hopefully I can get some help on this one.
In order to drill down into my data as much as I would like to I created a PivotChart and added in slicers. It took a total of about 4 slicers to really allow the user to go as far as they wanted to and my Boss thought that there was too much going on and didn't like the layout.
I set out looking for ways to do it using ControlForm Dropdown list's. I came across a couple of videos but the one that helped me the most was from Chandoo.
https://www.youtube.com/watch?v=FW89ITnAq2Q
http://![](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FXWeaOAY.jpg%3F1&hash=998c2dc94c2c907b0b566ca8a614b086)
I accomplished this by creating individual tables on the same sheet as my Pivotchart and connecting the dropdowns to both the named tables I created and the filters on the PivotTable. Thus when Select a Category on the 1st dropdown it filters the PivotTable and PivotChart accordingly using Modules.
It got me to where I am at now, but I have been spending way too much time trying to figure out how to reduce the options for the "Sub-Category".
My second dropdown gives the user the option to select various equipment sizes, or "Sub-Categories" of the Category selection. The problem is that the Sub-Category drop down list all options for all categories. I would like to get it to only show options for the chosen category.
Also, instead of doing this off of individually created tables I would like to have it pull directly off of the pivot table or the dataset.
PLEASE HELP!!!
Hopefully I can get some help on this one.
In order to drill down into my data as much as I would like to I created a PivotChart and added in slicers. It took a total of about 4 slicers to really allow the user to go as far as they wanted to and my Boss thought that there was too much going on and didn't like the layout.
I set out looking for ways to do it using ControlForm Dropdown list's. I came across a couple of videos but the one that helped me the most was from Chandoo.
https://www.youtube.com/watch?v=FW89ITnAq2Q
http://
![](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FXWeaOAY.jpg%3F1&hash=998c2dc94c2c907b0b566ca8a614b086)
I accomplished this by creating individual tables on the same sheet as my Pivotchart and connecting the dropdowns to both the named tables I created and the filters on the PivotTable. Thus when Select a Category on the 1st dropdown it filters the PivotTable and PivotChart accordingly using Modules.
It got me to where I am at now, but I have been spending way too much time trying to figure out how to reduce the options for the "Sub-Category".
My second dropdown gives the user the option to select various equipment sizes, or "Sub-Categories" of the Category selection. The problem is that the Sub-Category drop down list all options for all categories. I would like to get it to only show options for the chosen category.
Also, instead of doing this off of individually created tables I would like to have it pull directly off of the pivot table or the dataset.
PLEASE HELP!!!