Range Average Qlikview

[#1]

I am trying to calculate a moving average for customers. I want my table to show me the average of each customer based on his previous months data available. When I make a selection of a particular customer the table works fine. But problem arises when there is no selection on Contract. The table does not aggregate the moving average w.r.t to Customers. The query that i am currently using, which works fine for each Contract when selected, is:

Rangeavg(Above(TOTAL Sum(UnitBilled), 1, Rowno(TOTAL)))

However when there is no selection made the table shows the following details:

For each contract i want the table to show his own moving average. Like it is doing so for A in the above table.

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Try removing the totals from the expression so the rangeavg does not cross the borders of the contact dimension:

Rangeavg(Above(Sum(UnitBilled), 1, Rowno()))

[#3]

thank you Gysbert, it worked!