Sales Budget Ad Hoc reports
The measures used in Sales Budget Ad Hoc reports are sourced from the Sales Analysis and Sales Budget facts. These measures are analyzed by Invoice Date and Sales Budget Date, and use the Sum aggregation.
Dynamic Metric History
Description: Using this report, you can compare the Sales Actuals value versus the Sales Budget value by month. The columns represent the Sales Actuals values and the points represent the Sales Budget values.
Measure: Dynamic selection of measures with Metric Ad Hoc – Actuals and Metric Ad Hoc – Budget filters
Chart type: 2 data series combo, 1 line chart on Y axis 1 and 1 column chart on Y axis 2
Budget vs Actuals Diff in Pct Ranking - Top
Description: This report shows the top 5 records based on the difference percentage between the Sales Budget values and Sales Actuals values.
Measure: Diff Pct
Chart type: 1 data series bar chart
Budget vs Actuals Diff in Pct Ranking - Bottom
Description: This report shows the bottom 5 records based on the difference percentage between the Sales Budget values and Sales Actuals values.
Measure: Diff Pct
Chart type: 1 data series bar chart
Sales Budget Summary by Period
Description: This report shows the summary of the Sales Actuals value, Sales Budget value, Difference, and Difference percentage. Using this report, you can compare the Sales Actuals value versus the Sales Budget value by month.
Measure: Dynamic selection of measures with Metric Ad Hoc – Actuals and Metric Ad Hoc – Budget filters, Diff, Diff Pct
Chart type: Cross table