9 Replies Latest reply on Dec 28, 2018 9:25 PM by Mahfooj Khan

# How to sort side  by side chart based on high value?

Hi,

I would like to sort based on high value using side by side chart for different months. My bar chart should be like this (Left side Highest value to the right side lowest value).

Kindly advice how to achieve this. thanks

Attache workbook fyi

• ###### 1. Re: How to sort side  by side chart based on high value?

Please find the attached workbook with sort.

Workbook version 2018.2. Let me know if it helps.

• ###### 2. Re: How to sort side  by side chart based on high value?

How you did? i dont find the solution inside. It still shows the same graph without proper sorting.

• ###### 3. Re: How to sort side  by side chart based on high value?

Hi,

Create a calculated field (Sort) using RANK(SUM([Sum]),'desc') and make it discrete.

Drag this field in between your date and dimension in column shelf and compute using Labels

Let us know if this help.

Mahfooj

• ###### 4. Re: How to sort side  by side chart based on high value?

Hi,

Please find the below attachment as well as screen shot marked as Correct or Helpful if it is working.

Note: Refer Sheet 2 and Sheet 2

Sort by Sum filed.

• ###### 5. Re: How to sort side  by side chart based on high value?

I sorted the label as per "sum' then sorted 'sum' again on chart. by that nested sort will happen.

Or you can follow either Mahfooj's or Amar's approach.

• ###### 6. Re: How to sort side  by side chart based on high value?

Hi,

Please find the updated solution below marked as Correct or helpful if it is working.

Note:=Sheet 2 and Sheet 3

• ###### 7. Re: How to sort side  by side chart based on high value?

Thankyou very much for all the replies.

• ###### 8. Re: How to sort side  by side chart based on high value?

Mahfooj Khan. Any idea how to bring the month label down that you have mentioned in the chart above? thanks

• ###### 9. Re: How to sort side  by side chart based on high value?

Hi,

Is that what you want?

Workbook attached for your reference. Hope this will help.

Mahfooj