PBCS- How to create an Account dimension with Years members
Summary
How to create an Account dimension for calculating prior year dataContent
Hi,
I need to know how to create an Account dimension that shows prior years data (such as Prices) starting from actual.
For example, with a IF function I'd like to show prices of 2021 or 2020. But the following statement retrieves only data from FY20, so there is something wrong in the first condition.
IF (@ismbr("FY22"))
"Prezzo_r"->&PrevYear->&PrevMonth;
ELSE
"Prezzo_r"->FY20->Jul;
ENDIF;
Version
21.08.83
Tagged:
0