This topic provides information on the use of Advanced Variance Crosstab Columns when building or updating a Crosstab Definition.
File variance calculation
Provides different variance analyses of current data file vs other files. This means that the source data does not have to be pulled through into other columns unless needed elsewhere.
Calculates the variance in volume using the formula: (File A units – File B units) * File B price.
Calculates the variance in price using the formula: File A units * (File A price - File B price).
New product variance
Calculates the correct variance in new products since they began trading. For any month within one year of the item’s Launch Date, the volume and price variances are set to zero and the total variance (excluding exchange) for the month is assigned to the special variance category New product.
Calculates the variance caused by movements in exchange rates using the formula: File A value @ File A rates - File A value @ File B rates. This will require you to have a currency set that is different from your Default Currency, otherwise there will be no exchange variance.
For other Column Types, see Crosstabulation Column Types.