How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory?
I tried the following and got errors:
Sales_Revenue[lookup: territory_id, lookup: PY ar_date]
Sales Revenue[sum: territory_id, sum: PY ar_date]
Hello @zdlee ,
have you tried to convert the date into the period required for the module dimensioned with time?
You would just have to create a line item dimensioned by that time period and reference your date dimensioned line items using PERIOD() [https://help.anaplan.com/110a2a13-de1b-4274-82ee-c4ecd5e2dc90-PERIOD]
Please let us know if that does not resolve it.
@BrunoRodriguez I got it to work using period. Thank you!0
Happy to help!0