Question
Eduard Lebedyuk · Jun 3

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:

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
00
1 0 1 75
Log in or sign up to continue

%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]