How to sort items based on spend and i need figures based on savings in the pie-chart

[#1]

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

[jonathandienst]

How do you get the top 3 to be 15, 20, 12?

[sunny_talwar]

I think based on the Spend column

[sunny_talwar]

May be this:

If(Rank(Sum(Spend)) < 4, Sum(Savings))

[sunny_talwar]

or

Sum({<[Item ID] = {"=Rank(Sum(Spend)) < 4"}>}Savings)

[#6]

Thanks for your assistance, but both are not working.

[#7]

You have any other formula?

[sunny_talwar · Accepted solution]

Seems to be working for me

[#9]

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?

[sunny_talwar]

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