Sales Analysis Ad Hoc report

The measures used in Sales Analysis Ad Hoc report are sourced from the Sales Analysis fact. These measures use the Sum aggregation.

Sales Margin Table

Measure: Invcd Gross Amt, Invcd Net Amt, Gross Profit 1, Gross Margin 1 Pct, COGS Standard, Total Disc Amt, Total Disc Pct

Chart type: Table with dynamic selection of attribute in Row Ad Hoc – SA filter

Filter information: The Currency Type filter enables the user to switch between amounts in company, division, and transaction currency.

Parameters used in the report: Row, Date, Currency Type