Hi,

I am using Excel 2013 to connect to an OLAP Data Source. I am trying to create a stack back that adds the value of two measures:

• Cases that are SLA Compliant
• Cases that are not SLA Compliant

The Axis is the caller name (the customer).

I know how I can sort each independent measure in the chart, but I do not know how to sort out considering all values. Consider this simple example:

(note: I did this test using an Excel table. But in the real scenario the data is coming from an OLAP source).

So if I create a chart, this is what I get in Excel:

As you can see, the chart is not sorted by default. I want to be able to sort from largest to smallest but not either by the blue or by the orange legend -- but by the sum of both legends. That is, the total height of the bars.

Is this possible?

Thanks for the advice and support.

Regards,
P.

• Edited by pmdci Friday, June 26, 2015 10:06 AM

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"