Now I see that solution is not right...
For example, some orders maybe opened in May and closed in December. They will have OrderDate in May and completed in December.
But all months in between this order will be in WIP (June, July ... December).
Attaching the current application in QS.
I think I need to tweak with data model - it looks some additional columns may help. !
Calendar Tests.qvf 176.0 K