Forum Discussion
Variance by Contracts
Variance by Customer Name: I have listing of contracts that are tied to 2% rebates. The Matrix I have "Variance by Customer Name" shows variances. Variance is calculated this way: Forecated Reve...
Anonymous
If you put contracts (like ContractID or Contract Name) in a matrix, then you should create a measure that will return 1 when a contract has a rebate and 0 when it doesn't. Then use the measure to filter out the contracts without rebates using the Filter Pane for the visual. This is how you get rid of certain contracts - by creating a filtering measure.