Hi
We are coming to a new year, our fiscal year starts Nov, and wondering on how I can see historical data on my dashboard. Most of my beast modes are YTD like these 2 below. On the first month of 2021, my data will all change to just one month. How can I get a full year data for 2020 for historical review. Is possible to save a historical page? Your advise will be greatly appreciated. Thank you in advance.
BM Sample 1: YTD Gross Rev:
SUM(CASE WHEN `Year`= `Year for Today` AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END)
BM Sample 2: YTD Gross Rev % Change:
(SUM(CASE WHEN `Year`= `Year for Today` AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END)/
SUM(CASE WHEN `Year`= `Year for Today`-1 AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END))-1
End