I'm wondering if there is a way to consolidate data labels into one. Here's a simple example for context: if I had a pie chart with labels "Apple", "Banana", "Grapefruit", "Broccoli", "Lettuce"-- is there a way for me to group the data associated with "Broccoli" and "Lettuce" into a "Vegetables" label? I don't really even need to reference "Broccoli" and "Lettuce" afterwards, I would just need the "Vegetables" label that aggregates them into one label.
Any and all help would be great.
Thanks!
Here is an example of how to combine defects into "Open" and "Closed" categories based on their State attribute that has four AllowedValues: