I am trying to recreate the following table. I do have a Dimension (date type) that is called Reporting Month...
and I need Current Year to be "changeable"... Mainly when we go into the next year. Because in the middle of January 2017 there will be no data until the end of the month so the manager will want it flipped back to 2016.
|Employee Name||Current Year (Total)||Prior Year (Total)||Dollar Change (Total)||Percent Change||Current Year. (Total)||2 Year Ago (Total)||Dollar Change (Total)||Percent Change||Current Year.. (Total)||3 Year Ago (Total)||Dollar Change Three (Total)||Percent Change|
If you ask a more specific question and provide a packaged workbook, we can try to get you a solution. Otherwise, our community has some great threads about this topic that may help: