Hi Piyush,
I recommend you to create a measure which takes the over all result value for Measure 1 for the past quarter and similarly create measure 2 based on overall result for expiring conracts, Then build a query
Your measure 1 and Measure 2 always displays overall result value for the respective quarters and never segragate based on months, Hope by this way you can achieve your requirement?.
Feel free to let me know incase of issues.
BR,
Lakshmikanth Adharapurapu
Add comment