DAT02 PY Revenue to CY module
Hi, I am having trouble with the formula in the DAT02 PY Revenue to CY module.
Steps I have performed thus far:
1. Pulled from the Historical Data in the Data Hub into the DAT01 module in the Sales Planning model (dimensioned by A1 Accounts, P2 Products and F19 Time Range)
2. Created DAT02 module in the Sales Planning model to pull data into future quarters (dimensioned by A2 Accounts>Product# and Time)
3. Inputted a lookup formula to reference the DAT01 module (source) and the SYS03 and SYS00 modules and below is the result. Seems to be aggregating at the account level for each product. Any guidance would be greatly appreciated!