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]


Best Answer

Answers