I'm creating a KPI card, which displays a sentence.  I want certain aggregated values to programmatically change within the sentence.  to do this I create a table and force certain values into one column, hide all the other columns and use that to create a sentence that changes with a new data upload and/or parameter change.

This Measure is aggregated

sentence

Since <Par Year> Op Ex have incresed from ______ to <AGG(PMPM)>

(<% Difference in AGG(PMPM)>)

" Since 2015 Op Ex have increased from 334.17 to 350.56 (4.903%) the blank is where I want "parameter(year) value" to show

The problem is that to create this type of sentence you have to have all the values in one column.

I basically want to force (see attachment) 2015 value (whatever the parameter is displaying) to show up in 2017 column.  it would probably default to show in all columns.  so if 2016 was selected then 348 would show in blank etc.

Maybe there is way to reference a specific years value in the test but I haven't been able to find it