Set Analasys

[michael84]

Hello

I got the following bar chart with the following formula:

My current selection is Year = 2012.

Avg

( {$<Year= {$(=only(Year))}, Diff_Terminvergabe_Untersuch={">0"}, Patientenart= {'ambulant'},

Diff_Terminvergabe_Untersuch={
"=(Avg(Diff_Terminvergabe_Untersuch)+(Stdev(Diff_Terminvergabe_Untersuch)*3))>=Diff_Terminvergabe_Untersuch"
} >} Diff_Terminvergabe_Untersuch)

The socond formula ist the same as the one above, only the expressen Year= {$(=only(Year)-1)

is supposed to show the 2011 values, but it won't as i want... In fact 2011 should look like 2012. When removing "Year= {$(=only(Year))", then it's working as long as the current selection ist 2012 and 2011. But thats not how i want it...

Thanks for your Help

Michael

[michael84]

Unbelievable you made it… Thanks a lot for your help!!!