Pivot Formula Not Working in Line Graph

[pkelly]

Hi...

I have the following formula which works okay in a pivot table...

=

IF(cam_Sequence >11,rangeavg(after(sum(sin_Qty),0,12)))

I have been asked to show this as a line graph but am getting "no data to display" returned...

I think I have read other posts that formula that works in pivots may not necessarily translate to graphs...

Does anyone have any ideas how I can get this formula to work in a line graph?

[#2 · Accepted solution]

Hi Paul,

see QV help. "After" is for pivot table only. Try to use an expression like this:

RangeSum

(above(Sum(UmsatzBestZeile), (above(Sum(UmsatzBestZeile), 0, 3)) or below

Good luck!

Rainer

(above(Sum(UmsatzBestZeile),