filter by year / period instead of date

got it,
what about if I have 2 column, where column1 is current period, and column2 is previous period,
and I allow user to specify year/period for column1, and column2 is calculated based on column1.
then when column1 is Jan/2017, how to set column2 to be Dec/2017?


Please sign in to leave a comment.