Clarifying the issue with an example:
A column with scenario descriptions "Budget" and "Actual" , and a column with expenses ($) are stored in a dataset with lets say 1000 records. Creating a matrix in the report view, adding "scenario" to the rows and "expenses" to the value field. This returns, lets say, Budgeted Expenses equal to 5300 KUSD and Actual Expenses of 5500 KUSD. I want to retrieve the variance as a negative value (5300-5500) but can not do this easily by adding a column to the matrix and subtracting Budgeted Expenses with Actuals Expenses. The work around of creating measures and then adding those to columns in a matrix and adding visual calculations are very inefficient; and adds unnecessary excessive measures only causing confusion and extra work.
nschachter
on:
Tags/Labels to structure all fabric content
on:
Fabric free trial
Sorry if I don't understand, but you could just add a Visual calculation like: VC = [Budgeted Expenses]-[Actual Expenses]?