I want to make a slicer form where the user determines what data will show.
I.E. A mechanic is in the field and wants to see all the repairs that have been inputted for a specific piece of machinery based on the it’s equipment ID. When he types in the ID all reports involving that ID should appear. Now if this same mechanic wanted to only show the repairs that were done on the engine he would able to filter it more by saying the Engine repair field = Yes and all the other repairs for that Equipment ID that didn’t involve the Engine would also disappear.
How can I do this?
Basically trying to make a dynamic slicer form.