Thanks for your response! I'm having a hard time understanding..Can you help explain how to get the "Measure Names" and "Measure Values"? What do they include?
Thank you so much!
Sorry, I guess I didn't explain clearly. What I would like to achieve is by comparing the forecast of FY19 (Jul-18 to Jun-19) with the actual $ sales of FY18 (Jul-17 to Jun-18) instead of comparing them the whole period. I don't know how to get the correct date in the function.
For example, for chair, the desired result would be:
Actual $ of FY18 4,890,032
Forecast $ of FY19 1,144,188
FCST vs. Actual % chg -76.6%
Can you please help me with this? Thanks!