I tried to search for what I'm trying to do but I didn't know how to word it exactly. I would like to create a pie chart but combine values. In other words, my data looks something like this:
If I make a pie chart right now, it will show me:
As expected. However, I'd like to somehow combine the values, so the output looks more like this:
I considered making a calculated column somehow but I didn't know what to put in it: If([Instrument]="Piano",........?)
Could someone please help me out?