I have the data in the below format
vendor amount
a 100
b 200
c 300
d 400
Now in the chart i want the category names as a,b,other(c,d should appear as
other). Total amount of c and d should show up for other. Can you please
suggest how this is possible.