I have data of Customer Code, Primary Customer and Subsidiary Customer I want to be able to filter on the a union list containing both primary and secondary customer, but data for all customers with the same customer number on the sheet.
For this example the user chooses Company T and I want to return all data for customer 1234.
답변 2개
You could use a parameter to select the [Subsidiary Name] and then have a calculation of:
[Customer Number]
=
{ FIXED: MAX(IF [Subsidiary Name] = [Subsidiary Name Parameter] THEN [Customer Number] END)}
