if you add parameter selected data then set it will work fine.
Please attach the workbook here.
I've edited my initial post to attach a simplified workbook with altered data.
Not sure what you mean by 'add parameter selected data'.
I was hoping some solution to this problem would be in the forum.
If you mean by "parameter selected data" using a parameter to specify the contents of a set, I have done that.
In my sheet, I have defined a hierarchy that includes Employee Team and Employee. I am getting the number of occurrences (number of records) as a bar chart extending from each employee.
I want the sheet to show the rolled up team numbers when the hierarchy is collapsed and the team name and employee name when the hierarchy is expanded.
Here is my problem. When I define the specifications on the Rows with the hierarchy expanded I chose "Show Members In Set" This then shows the chart exactly as I want it.
If I collapse the hierarchy to move to the team level and then expand the hierarchy again, the employee set column changes to "Show In/Out of set" Since everyone is in the set, which is why the parameter is being used, I get one line (IN) for each Team. As yet, I have not been able to find a way to prevent the column from reverting to Show In/Out of set.