Here's how you do it all dynamically, not need for parameters. Just use a lot of date functions
In the attachment:
TW = This Week
LW = Last Week
TM = This Month
LM = Last Month
TQ = This Quarter
I didn't do LQ because there wasn't any data, but you would just set the filter to 3-5 (remember that the quarter calc is zero based so the 3 months in the quarter are 0,1,2.
If your quarter is not "the last 3 months" then you just need to write more code to calculate it better.
Previous Week_MTD_samesheet CM.twbx 157.3 KB
Thank you so much Chris for your help. It really encourages people like us to not give up & keep trying.
This helps, but as u see you have different sheets for TW, LW, TM, LM. I want all these views in one Sheet.
The report demands to have these as separate columns and not in separate sheets. (For better comparison of data).
Any thoughts on that?
Also, my quarter is from 3.31 to 6.30, would the code come in Month diff?
Hi @Chris, should I expect to see you at TC18?
It would be tricky to do it on one sheet, you would probably have to create a lot of LODs and other calculations.
Why does it "must" be in 1 sheet ? Why not a dashboard ?
I'll be there make sure you stop me and say Hi, but I'm probably running off to somewhere else as well.
It would be a pleasure! Thank you. Hope to see you soon!