AnnaGrammeAnnaG
11 years agoQrew Member
Pie Chart - Combine Values
Hello all,
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:
- Piano: 10
- Banjo: 1
- Flute: 1
- Guitar: 3
- Sitar: 2
If I make a pie chart right now, it will show me:
- Piano: 59%
- Banjo: 6%
- Flute: 6%
- Guitar: 17%
- Sitar: 12%
As expected. However, I'd like to somehow combine the values, so the output looks more like this:
- Piano: 59%
- Other: 41%
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?