1 of 1 people found this helpful
Without looking at your workbook, you can use look up table calculation.
Let me know if this helps.
see the attached
Couple of issues - you have created a number of separate measures that you now want to use in your % change calculation - but because they are unique they get treated individually
there are a couple of ways around this - the first and easiest is to pivot the data but I think you are pulling the data from a DB and you may not be able to pivot the data
second you may be able to pivot the data using a custom SQL procedure
but there may be an alternative with the data as it is - I looked as some of the calculations and it looked like you may be able to use filters to get the same results
I added a formula - just to count D the patient CIDs
this returns this (for your sheet 4)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
BH Dashboard_v10.2.twbx 65.7 MB