PBCS- How to create an Account dimension with Years members
SummaryHow to create an Account dimension for calculating prior year data
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.