TOTAL function in chart

[pepe2209]

Hello

I have a chart with dimension variable: LastYear (per month)

Now I want to show one line with the average of Value of the selected ID(s): avg(Value)

and one line which shows the average of Value over all ID's: avg(TOTAL <LastYear> Value) ??

But this is not working, with this expression the result is still limited to the ID selection and I want it to be an average over all ID's no matter the ID selection.

is this possible?

your help would be much appreciated

regards

Peter

[#2]

Hi,

you can to use the set analysis ..... {<ID=>}  in this way, not applicate the filter criteria on ID field.

[pepe2209]

Ok thanks, this indeed works when I make a selection in the field ID

But ID is not the only field in which i can make selections... so i want the total average to work no matter ANY selection made.

[#4]

avg( {1} Value ), 1 there will ignore all the selections and includes the dimensions in your  chart.

[#5 · Accepted solution]

Ok, then you test this .....

( {1} )  in this way you consider ALL

[pepe2209]

Ah yes thanks!

this is exactly what i need.

thanks again.