Hello,
I have a product dimension and a calendar dimension.
I have 2 KPIs, one is Amount_N, the second one is Amount_N-1.
When we select a year, we just have products Amount N and N-1 that have something in N (product dimension is filtered by the year selection).
We would have also the products that do not have amount in the selected year, but that have an amount the year before (in the Amount_N-1 KPI).
How can we do that?
Regards,