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 B) 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.




Thank you.

Best Answer

  • Hi @sosunkwo 


    Please find the below solution, hope it helps.


    you can filter the the view by filter line item.