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]