This is a related question, although not about dates.

The client wants to see QTD figures for the current year and Quarterly figures for the 4 quarters of the prior year. When I use {1}[4]Q, instead of showing the 4th quarter figures for the prior year, it shows zero, unless I select period 12. But we are in period 2. I want it to show the total no matter what period I select.

What code do I use for that?

Thanks

Steve