I have a page with diagrams for sales.
I have a control element where the user selects a vendor is select – filtering all page diagrams to sold items from that vendor.
I want to add a table with detail item lines (pivot grouped by customer, invoice …). In that table I want to see all invoice lines – including lines with items from other vendors. ** Notice: This table should still only show invoices that contain at least one item from the selected vendor.
How do I do that?
Is it possible to connect a second data source with a (customized) relationship to control elements based on the first data source?)