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
Seems to be working for me
How do you get the top 3 to be 15, 20, 12?
I think based on the Spend column
May be this:
If(Rank(Sum(Spend)) < 4, Sum(Savings))
or
Sum({<[Item ID] = {"=Rank(Sum(Spend)) < 4"}>}Savings)
Thanks for your assistance, but both are not working.
You have any other formula?
Seems to be working for me
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