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
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
Solved! Go to Solution.
I have multiple spend amounts and multiple saving amounts for the same item, sorted top 3 items using table based on spend, so all spends and savings came to one one number for one item, then i tried the above formula but it is showing based on top 3 savings only. Is this because of multiple spends and savings?
I don't think it should be a problem, but if you are able to share a sample where you see an issue, we can dig deeper into it