...
- Revenue in Time Period 1 – Total revenue in Time Period 1.
- Lost Business – Revenue from lost customers + Revenue from Retired Products + Revenue from current customers not buying products in Time Period 2 (who did buy the same products in Time Period 1).
- New Business – Revenue from new customers + Revenue from New Products + Revenue from existing customers buying products in Time Period 2 (who didn't buy the same products in Time Period 1).
- Price Effect – Changes in total revenue due to changes in Price Per Unit of all products.
- Volume Effect – Changes in total revenue due to changes in volume of goods sold to customers.
- Portfolio Mix Effect – Changes in total revenue due to change in mix of sales (changes in proportions of a product's sales to total sales for time periods in question). For example, over a given time period, increase in share of a high-priced product will contribute to revenue positively and vice versa.
- Other Effects – Anything not accounted for by any of the above-mentioned effects.
- Revenue in Time Period 2 – Total revenue in Time Period 2.
Technical details of the dashboard creation:
...