Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)