topic Re: How to sort items based on spend and i need figures based on savings in the pie-chart in App Development

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

Thu, 16 Feb 2017 08:09:20 GMT

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

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

jonathandienst — Thu, 16 Feb 2017 13:27:03 GMT

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

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

sunny_talwar — Thu, 16 Feb 2017 13:28:51 GMT

I think based on the Spend column

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

sunny_talwar — Thu, 16 Feb 2017 13:29:25 GMT

May be this:

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

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

sunny_talwar — Thu, 16 Feb 2017 13:29:57 GMT

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

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

Thu, 16 Feb 2017 14:52:01 GMT

Thanks for your assistance, but both are not working.

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

Thu, 16 Feb 2017 14:57:11 GMT

You have any other formula?

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

sunny_talwar — Thu, 16 Feb 2017 15:00:49 GMT

Seems to be working for me

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

Thu, 16 Feb 2017 15:12:45 GMT

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?

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

sunny_talwar — Thu, 16 Feb 2017 15:15:10 GMT

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

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

Thu, 16 Feb 2017 15:22:57 GMT

My Skype ID : nagarjuna000024@hotmail.com,

If you are free just send me the request we will discuss it. I will be available after one hr.

Thank you

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

Anonymous — Thu, 16 Feb 2017 15:23:25 GMT

=if(

Aggr(Rank(Sum(Item ID)), Spend)<=3,

Savings,

'Others'

)

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

sunny_talwar — Thu, 16 Feb 2017 15:24:23 GMT

Unfortunately, I cannot... May be somebody else can offer assistance

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

Fri, 17 Feb 2017 07:42:31 GMT

This is my sample data, if u get this correctly then probably works for me. Please do this favor

Item ID	Spend	Savings
5112	3000	1500
5112	20000	4000
5112	25000	3000
6113	34560	2000
7889	56000	4000
9887	670000	6000
6113	34520	4000
9887	120000	1200
7889	3000	1000
5112	75000	12000
7889	10000	2000
9887	14000	1400
6113	98760	20000
3456	34560	10000
6113	100000	30000
7889	2000	200
4562	456890	8000
6113	2000	100
5112	60000	7000
3452	23480	4000
9870	18000	1800
9870	26000	2000
3452	35000	5000
6113	5000	500
9887	12556	1234

Thanks in advance

Regards

Nagarjuna.

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

sunny_talwar — Fri, 17 Feb 2017 09:35:44 GMT

Is this the expected output?

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

Fri, 17 Feb 2017 09:49:06 GMT

Thanks @ sunnny Talwar, now it works for me. I need one more favor , Can i sort only top 2 item? i.e not item 1 and item 2 . It should display only 2nd item based on spend. It should work without match function.

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

sunny_talwar — Fri, 17 Feb 2017 09:53:42 GMT

Hahahaha now it works? I did not change a single thing except using the new data. Expression stayed the exact same.

Try this for 2 items

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

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

Fri, 17 Feb 2017 10:09:24 GMT

I did one mistake, now i understood what it is for the earlier one.Here i need only 4562 item and not 9887 , I have more columns like savings 1, savings 2 and etc for all items , here i want to use bar charts for one item ID , I want to 10 charts for 10 item IDs so wanna sort each item ID i.e Item 1,2,3, and etc is this possible? when i sort item IDs it should display based on spend only.

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

sunny_talwar — Fri, 17 Feb 2017 10:16:36 GMT

What is a point of pie chart with just one item? Anyways, try this

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

I have no idea what you mean here:

I have more columns like savings 1, savings 2 and etc for all items , here i want to use bar charts for one item ID , I want to 10 charts for 10 item IDs so wanna sort each item ID i.e Item 1,2,3, and etc is this possible? when i sort item IDs it should display based on spend only.

Can you share a sample and also please provide the desired output from the same provided

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

Anonymous — Fri, 17 Feb 2017 10:18:13 GMT

Dear Nagarjuna Vattikuti

fine the attach file and pay attention to Dimension Limits tab and sort tab