Custom calculated column in Matrix

[HB2BI]

Hello all,

until just now i've been able to pretty much find an answer to all my questions using these fora, thanks for that!

I'm trying to add a 'custom' column to the end of my matrix.

Right now it looks like:

	Q1		Q2
	Actual	Forecast	Actual	Forecast	TOTAL ACTUAL	TOTAL FORECAST
Sales	100	50	75	200	175	250

When i add a calculated column (DIFFERENCE = Actual - Forecast) this is also done for the Q1 and Q2 values.

I want the calculation to be done only on the TOTAL ACTUAL and TOTAL FORECAST values, as so:

	Q1		Q2
	Actual	Forecast	Actual	Forecast	TOTAL ACTUAL	TOTAL FORECAST	DIFFERENCE
Sales	100	50	75	200	175	250	-75

I've tried a lot, and haven't had any luck. Who can help me out?

Thanks!

[pa_trick67]

Hi @HB2BI 

What does your table look like?

You can try column=[actual]-[forecast]

[parry2k · Accepted solution]

This is currently not possible but one way you can control is to create measure to return value only when it is total otherwise return blank. This way you will have the column there for every quarter but there will be no value. Just a suggestion.