I have a group of tables all connected by an id:
plus many more fields for the three tables.
I would like to make a pivot table that is displaying this information.
Then I would like to have an input box where a person would be allowed to enter a ticket number.
Pivot chart order would be like: item_id -> display name -> ticket_type -> ticket number
The issue I'm running into is this: say a ticket number is selected, this ticket number will not (I can verify on my end) match a ticket number of a different ticket type. As a result, this will exclude all the other ticket types from the item they are connected to. I would like for them to be displayed.
Essentially I would like to display all the information of an item where that item happens to have a ticket with a number that matches what is entered.
I think I could maybe do this with set analysis and an expression, but there really isn't anything I want to aggregate over my data for in this particular example. Is there a way I can do set analysis on a chart without using any type of aggr function? Thanks.