This content has been marked as final.
Show 3 replies
-
2. Re: How to create dynamic YOY % chg by comparing two different measures
Yidou Li Sep 7, 2018 9:55 AM (in response to Zhouyi Zhang)Hi Zhouyi,
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!
-
3. Re: How to create dynamic YOY % chg by comparing two different measures
Yidou Li Sep 7, 2018 10:01 AM (in response to Zhouyi Zhang)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!
Yidou