|Crosstab Name||Volume, Price and New Product Variance analysis in local currency - Quarterly|
|Description||Shows the variance and % variance in terms of Volume, Price and New Products introduced.|
|Number of Files||2 Summary Files required|
|Database Validity||Can be applied to all Sales and P&L databases.|
|Variants||Volume, Price and New Product Variance analysis in local currency Volume, Price and New Product Variance analysis in local currency - Monthly|
|Extra Notes||Variances shown are for file 1 vs file 2, hence the sequence of files is significant.
Does not use any classification variables, so is applicable to all sales databases.
These figures are based on quarterly and annual information.
Period must be January to December.
Variance option must be Period Totals only.
You would like to compare two or more files using a quarterly and annual summary, concentrating on the variance between the files selected. You also want to look at the variance in further detail, in terms of Volume, Price and New Products within the selected year, as well as their percentages.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.
Please sign in to leave a comment.