Hello,
I am showing Year, Month and Customer Counts in report. My requirement is to calculate Current year YTD and Current YTD Month Ago and get the difference or growth on these measures. So I am using
TODATE(Customer Counts, Dimension Date.Dim Date.Year)
for current YTD which is giving intended results. Now I want to calculate YTD month ago for same year and I am using
AGO(TODATE(Customer Counts, Dimension Date.Dim Date.Year), Dimension Date.Dim Date.Month, 1)
which is giving error of [nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not supported.
How to achieve this calculation.
Help would be appreciated.
Thank you.