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
Discussion (1)0
Comments
%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]