I have the following metrics - Subs, Bound, Quotes. I need to have a table which needs this metrics to be viewed as Current year, prior year, 3MM CY, 3 MM PY, 6 MM CY, 6 MM PY. The table structure should be like this:
Current year Prior year 3 MMCY 3 MMPY 6 MMCY 6 MMPY
The 3 MM and 6 MM for both CY and PY should be rolling one. i.e. if we are in Jan , 3 MMCY should be Jan 2018, Dec 2017, Nov 2017
Similarly for 3 MM PY it should be Jan 2017, Dec 2016, Nov 2016.