Offset bar in bar chart with dimensions

[christophebrault]

Hi,

In a chart, i'm adding results of differents societies. Number of society changes depending on selections.

I want to have a bar chart  ordered form the best to the worst based on results AND an offset for each bar to make a cascade.

The offset must be equal to the precedent society. Look the set of data below.

Thanks

[rajni_batra]

Anything like this????

[christophebrault]

Yes, but no....

I want the same result but with only one expression because i have lots of society and hierarchy level, and i can't write an expression for each and because the order will change depending on results for different periods.

[rajni_batra]

PFA

[christophebrault]

No...

the qvw, the order is : C B A D

Offset for C is 0 because it's the first, offset for B = Cresults  offset for A = B results  etc

i tried to do it with rank, but without success...

[christophebrault]

No solution ? I'm always looking for...

[qliksus]

Hi add this in the Barr offset expression

if( isnull(Above(sum(Result))),0, Above(sum(Result)))