I work on an analysis to monitor, which sales order channel our customers use.
Therefor I need a button for each order channel, where a viewer can select all customers ordering e.g. via EDI at on click.
So the Viewer can analyse all customers with the possibility of ordering via EDI and can identify which other order channel those customers use.
At the moment, the viewer has to select via a filter “order channel” ‘EDI’, then select all customers and remove the EDI filter, because otherwise the viewer can see only sales order items received via EDI.
Can someone help me with the formula please?