In this example, a report is designed to identify and analyze transactions that negatively impact the margin.
- Identify the dimension columns and add them to the canvas as a table visual.
- Add the measures to the table including Sales Amount and Margin %.
- Apply a visual level filter to the Sales Amount such that each row represents a significant transaction or grouping.
Visual Level Filter Applied to Measure
- Turn the Totals off from the formatting pane given the filter condition applied to the visual.
- Apply a Table style such as Alternating Rows or use the Values and Column headers options to apply a standard format. ...
