When creating a Datamart report, it is sometimes necessary to drill-through the aggregated totals and see individual orders.
To enable the drill-through option:
- Select the blue “Report Options” button on your report
- Click “Show drill-through links on Measure cells” and then click “OK.”
Once completed, the report will refresh and you will now have the ability to click the hyperlinked totals.
Clicking one of the associated values will open a new window with another report showing the drill-through data. You can then export this data to a .CSV file to evaluate further.
Note: This option may take time to load and export depending on the size of the report.