Trying to get different values into the pivot table
Below is the code I am using in Beast mode. I want the "Not" metrics to be divided by MM to give me a value, and the MLR to be divided and the rest of the metrics to be total values. The pivot table is giving me total values. SUM(CASE WHEN MOS_Year = 2023 THEN CASE WHEN Metric = 'Member Month' THEN MM WHEN Metric = 'MLR'…
