Zhouyi Zhang PFA workbook, in screenshot yellow marked value should be calculated into separate column for previous year. I need to show only that value as kpi.
Create a calculation like below
you will get the required O/P
If there is any dimension filters add them to Context
Hope this helps kindly mark this answer as correct or helpful so that it will help others
In your view you can just create a prev year flag and remove all the fields from rows shelf.
prev year flag:
Put it to filter shelf and choose TRUE.
Hope it helps.
Retrieving data ...