I want to then select a supplier (via variable) and then have this pickup all documents that have this supplier and related data i.e. I choose supplier 'A' in the variable via an input field, and the chart then shows all docs (including all suppliers) and related sales data that at least have supplier 'A'.
Currently all my logic just filters out all the other suppliers (& documents) as soon as I choose supplier 'A'.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
