KPI within a KPI

[sharasridhar]

I have a data of your Fiscal years. 

I need to create a KPI which displays two values. The main one will give the CollectionRate, and the second one the CollectionRate for the year before. When viewing the sheet, when I use the Year filter to select 2017, the values should show 2017 rate along with 2016 rate. 

The year is taken from the patient admission date and the CollectionRate=TotalPayed/TotalCharged

[dplr-rn]

use set analysis and create your KPIs something like below. 

sales for the current/max year (or selected) Sum({<Year={"$(=Max(Year))"}>}LineSalesAmount)

sales for the previous year -  Sum({<Year={"$(=Max(Year)-1)"}>}LineSalesAmount)