How to plot values that depend on the whole result set in a diagram?

[uwe_martschinke]

Hello,

I'm currently trying to calculate and plot the average and the standard deviation of a measure. In order to do this, I created two variables with the following content:

= Average([XXX]) In ([XXX])

= StdDev([XXX]) In ([XXX])

where [XXX] stands for the name of the measure. If I drag the variables to a table, everything works fine. But if I try to create a chart where the category axis is a dimension exactly containing the values of [XXX], the values are calculated for single rows only. In other words: The mean of each value is the value itself and the standard deviation (naturally) is zero.

How can I tell the chart that these values should depend on the whole result set?

Many thanks in advance!