I am trying to figure out how to prorate a certain metric. The way it works is, we prorate the time customer service representatives are available to take phone calls in a quarter vs the total time there are at work since some of their time is allocated to doing projects. I have figured out the how to prorate in month 1 but I am not sure how to prorate in the months going forward. I am pretty sure there is an easy solution but I since I am new to Qlikview I am not sure.
Here is what I am trying to figure out:
In January, the prorate would be Prorate/1
In February, Prorate/ 2
March, Prorate/3
In Q2 the prorate resets to month 1 again and it becomes prorate/1 and so on.
