This content has been marked as final. Show 2 replies
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.