In the page, I made a filter that lists down "Q1, Q2, Q3, Q4" so the user can select the quarter he wants to see. I added another filter in the page to select 2019 only as well so that the numbers will show 2019 only.
I used the TOTALQTD formula as a measure to compute for the current QTD numbers the reader would like to see.
My next problem comes in when I need to compute for PREVIOUS QTD and LAST YEAR'S SAME QUARTER.
I tried the following formulas from dutchdatadude.com , replacing the correct column headers in these formulas, but I get error or no result at all.
Below is a screen shot of the report I have for now (the long table shows the correct numbers I want to see as a guide)
Hope somebody can help me out and advise the correct formulas to use!
To create a CALENDAR table should help. Please have a try. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Community Support Team _ Frank If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.