1 of 1 people found this helpful
You can try something like this. You can add more level of details in LOD as per your requirement in your original data If required.
If you've used some dimension filter in your original workbook then you can use INCLUDE instead of FIXED.
Hope this help. Feel free to ask If you've any query.
Thanks a lot for your reply! There is a slight problem though. I have data till June as of now. Your formula is giving me the correct number for Quarter 2 and YTD, but I am drawing a blank for Quarter 1. Can you please suggest a way to get Quarter 1 numbers.
Using datepart() you can get Qtr month then use this Qtr month field in your FIXED expression after Category. Then check.
Else provide me some more data in the same format.