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 Hans,

Thanks for that. It worked like a charm!

The instructions are a bit high-level so it needed some fidgeting from my side to make sense of it. But in the end the "total" field stays in the list of fields for the chart. I delete it not from the list of fields, but by selecting it from the legend in the chart then hitting DEL on the keyboard. Seems to have done the trick!

Regards,
P.