I was wondering is there a way to do this? for example I deal with university data within the UK. My primary filter is Campus location. When this is selected only the relevant universities will appear. however when I change location the cascaded filter remains on the university from the previous location making all my graphs blank.
Any help Appreciated
Please attach a workbook.