DeepSee: Comparision with the previous year
Is there a way in BI (DeepSee) to compare current value, to a value of a previous year?
For example I can hardcode this explicitly:
.png)
But I want in a widget to filter by year (1st column) and get the value for a previous year in a next column. YTY would be even better.
What MDX functions should I use? Examples?
Product version: IRIS 2020.1
%CELL is exactly what I need:
SELECT NON EMPTY { [DateOfSale].[Actual].[YearSold].&[2016], [DateOfSale].[Actual].[YearSold].&[2017], %LABEL(%CELL(-1,0) / %CELL(-2,0), "YTY", "#%;") } ON 0, NON EMPTY [Product].[P1].[Product Name].Members ON 1 FROM [HOLEFOODS]