Thanks. But I need filter action as the customer would like to view only the records corresponding to the selected Team and Rating (as well compare with other teams).
Is there any way to accomplish this with Filter rather than with Highlight ?
It seems that I'm not understanding well your requirement.
Now I've change the action to filter but just filtering by Rate. This means that when you click on an slice of the pie, the detailed table is going to be filter by rate value, keeping on the table all the teams by Project and Month with rate equal to the slice selected.
I hope this help,
ChartSlice_RM_v2.twbx.zip 53.7 KB
I know it is little confusing. I would like to apply the filter on both Team name and Rating and yet keep the remaining teams in the detailed table to compare against the selected team.
I want the detailed table to look like this.
Project Month Team1 Team2 Team2 Team3 Team4
ACBTR June 1 val val val val
ACBTR July 1 val val val val
ACBTR October 1 val val val val
HGTRE October 1 val val val val
HNROF August 1 val val val val
As I mentioned above, this complexity is due to the data format. If I had Team1, Team2, Team3 and Team4 as separate columns in my data, my requirement can be easily accomplished but since I have one column 'Team Name' with all the team name values, filtering out on team name is excluding the remaining teams.
Is there any way to accomplish my requirement without changing the data format ?