Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to sort items based on spend and i need figures based on savings in the pie-chart.I want to sort only top 3 items and this is my table
Item ID | Spend | Savings |
11 | 120 | 12 |
12 | 140 | 14 |
13 | 90 | 40 |
14 | 30 | 16 |
15 | 180 | 18 |
16 | 60 | 30 |
17 | 110 | 17 |
18 | 40 | 8 |
19 | 130 | 25 |
20 | 160 | 10 |
So pie-chart answer should be like this and NOT like this
Item ID Savings Item ID Savings
15 18 13 40
20 10 16 30
12 14 19 25
Thanks in advance
Regards
Nagarjuna
I am confused now. What all have you accomplished and what all are you looking to get help with? Can you provide a Excel example instead of attaching images?
I got the solution, anyway thanks.