Im trying to do partial filtering based on user selection on a report.
A crude example is in the attached.
Top left table is count of attendees, and shows how many events each attendee was associated with.
Table below this is a Status Breakdown, showing the statuses of each attendee for each event.
What i want is partial filtering, so when a user selects an attendee in the top table, the lower table is filtered by the Event, but not the Attendee.
e.g. User selects Anita in the "Attendee Counts" table.
"Status breakdown" table should show all attendees for events that Anita attended, i.e. it should ignore the Attendee filter context.
Default behavior is instead just to show rows for Anita in the "status berakdown" table as its filering on Event and Attendee.
As my status breakdown table doesnt have a measure i cant use calculate with various filters to do this. Is there a way this can be done in the front end?
Link to example
