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?