Hello,
I would like to autofilter a dimension based on the filter of another dimension. I have a hierarchy: "Supervisor" < "Manager".
I would like the dimension "Manager" be autofiltered as soon as the field "Supervisor" is chosen. I then have a measure in a bar chart that will respect that "Manager" filter.
For the dimension I've tried
=AGGR(ONLY({<GetFieldSelections(Supervisor)>} Manager), Manager)
or
=AGGR(ONLY({<Supervisor = {'=GetFieldSelections(Supervisor)'}>} Manager), Manager)
or
=AGGR(ONLY({<Supervisor = {'GetFieldSelections(Supervisor)'}>} Manager), Manager)
These didn't work. Any help would be great thanks!
Dana
