Only show moving average after 4 quarters

[Simon4]

Hi all,

I have a combination graph with a moving average for the margin. The moving average is calculated as follows:

rangesum(above(sum(OrderIntake) - sum(Kostprijs)

,0,4))/
rangesum(above(sum(OrderIntake)

,0,4))

OrderIntake = Revenue 

Kostprijs = costprice

A screenshot from the graph:

I need the moving average to start after 4 Quarters, because otherwise it will not be a correct average. What are the options to hide the moving average line in the first 3 quarters?

Thankyou in advance

Kind regards,

Simon 

[srchagas]

Hi, What about something like this?

{<Your_DATA_FIELD ={<">=$(First_Q4_You_Want)<= $(Last_Q4_You_Want)">}
rangesum(above(sum(OrderIntake) - sum(Kostprijs)

,0,4))/
rangesum(above(sum(OrderIntake)

,0,4))