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