I am trying to create a slice of a Table that has child records. The Parent record key is [Event ID] and has a Status column [Event Approval]. I am looking to slice the parents that have [Event Approval]="Approved" and the child table, "Event Information", has [Status]="Pending"
I have tried a few different ways and have not been able to structure an expression that captures the correct rows.
Any advice would be greatly appreciated. Thank you.
User | Count |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |