1 of 1 people found this helpful
I am on t 10.3 so I will show you the process below
you need to extend the range by using a datetrunc calculation
your window(min) becomes datetrunc('month',WINDOW_MIN(MIN([Order Date])))
The window max calculation is a little more complex
and it will give you this
If you need to stop the end date at July 31 you would wrap your new Window Max in another dateadd('day',-1,(the window max expression)))
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
your solution was simply superb.
Think I don't need to add new Window Max, Aug 1st will just be fine on my report at the moment as I have to pull previous days, quarters and years results as per user request.
Thanks for your help on this
Glad to help out