Also looking for a solution for this. I have product categories that have similiar measures names for each. I need to create a parameter that can toggle and display a different groups of measure names.
I created the attached workbook by linking two Excel sheets. The first sheet lists the schools with the number of positions within each school. The second sheet puts each position within a category as you described. Not sure if this is what you were looking for, but I gave it a shot. To get the categories color coded, I just dragged the category dimension into the chart itself.
Hope this helps!
Thanks very much for thinking about this one and putting that out there. In my case the big difference is in the data source. For me the data source has many rows, but three fields including
Grade Level and
Number of students
The position types are all calculated fields and I don't, at present, have the position categories established in the data set. So as a for instance I have a calculated field called
Assistant Principal where it is calculated as
IF SUM(Number of students)>900 then 2 ELSE 1 END
All the other positions are each established with their own criteria as a calculated field.
So in my viz I have School Name on the column shelf, Measure Names on the rows shelf, and Measure Values on the Text shelf. Then I have about 20 different calculated fields as measures. So it's all these measures, which don't already have categories attached to them in the data because the measure itself isn't in the data, that I need to group up.