Calculate average in pivottable

[#1]

Hi there,

i want to calculate a average of a factor in a column of a pivottable, irrespective of users selection.

Actually i have this in the formula for the calculation: 

avg(if(datum_test>=vStartDatum and datum_test<=vEndeDatum, fr_faktor1))

If field "factor" in table "factor_ratenschema" not filled, use the factors of last 5 networkdays.
Irrespective of users selection.

Hope somebody can help me.

Regards

Sabrina

[jonathandienst]

I suggest that you post a sample qvw to enable more accurate help.

[giakoum · Accepted solution]

Maybe it is because of the if statement. Replace it with set analysis (not very clear though):

avg({<datum_test={">=$(vStartDatum)<=$(vEndeDatum)"}>} fr_faktor1)