Parameter value as a Target/benchmark column

Hello quintans1,

Looks like you've already created a parameter. Create a Diff from Target measure like:

Diff from Target = [calcRatio] - [Target Ratio Value]

The trickier part is to show it only for the total. The only way I know of to do that is to turn off auto-size width, values text wrap and column header text wrap, then manually reduce the size of the Diff from Target column for all the non-total months to zero. I'm not 100% sure how it interacts if you change the column headers to something else but I think it's fairly safe since you're using calendar months.

This is what I ended up with:

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)