I have set up an advanced filter with a macro and slicers. The slicers allow choosing options under headers, then the macro is run to filter the data. So if a member selects Principal in the slicer, runs the macro, the data filters to Principal.
My problem is, if a member selects Superintendent, the macro runs and pulls both Superintendent and Superintendent Secretary. If I filter to Superintendent in the table, it only filters Superintendent.
Please assist. I can add my macro and some other details if needed.