I have a table with Scenario as a column and it contains values like Actual, Budget. I want to use matrix control ( or any other visual ) so I can show the values like following snap. When I pull Scenario column from table to "Column" section of matrix, it is showing me view with Actual and Budget But I want to show one more column next to Budget "Bud Var" which can show the variance.
Also Profit (on row) is the one which I want to calculated in runtime and it is Revenue - Direct Costs. Is this requirement possible using any visual ?