Pie charts - group by other

[#1]

Hi,

I wonder if you can help. Right now, if I select a company name in my dashboard, the pie chart is updated to show only that company value (like below).

What I would like to do, is be able to show 2 values in the pie chart. The value of the company that has been selected, along with the aggregated value of all other companies - simply marked as 'other'.

Is it possible to do this?

Thanks

[#2]

I think that bit now works ,.... phew! I forgot the '=' sign off your suggestion.

Thank you for all the help!!

[#3]

Great it worked as you want

Thanks

harshitha

[#4]