Filtered Summary View based on the presence of a list member
I'm stuck on the logic to create a filtered summary view.
I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a Large Group Size (i.e. Headcount total of 21 & above across all Work Groups.)
So in the image below: The summary view (table displays the cost center with a total headcount of 21 & above, and then for that cost center, the table displays only the work groups that are contributing to that total for a given Worker Type.
*Work Groups, Worker Type, and Group SIze are list-formatted line items.