Hi,
I am trying to build a dynamic pivot table and need your help.
I have a table with data and another sheet with 4-5 groupbox with 3 or 4 option buttons in each. Based on the combination of option buttons selected, I need to get a subset of the main data table. If there is a way to dynamically select dropdown fields in a pivot, this should be achievable.
Attached is an example which shows data and what is expected in resultant table. Even if Pivot is not possible any other method should do good. Since our boss does not like macro's she resisted an idea utilizing macros. Request if someone can put some light on this query using only formulas and radio buttons (without macros).
Thanks,
Praveen
Bookmarks