Filtered Summary View based on the presence of a list member

Hello, 

 

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.

sosunkwo_2-1664948979889.png

 

 

Thank you.

Best Answer

  • Hi @sosunkwo 

     

    Please find the below solution, hope it helps.

    ManjunathKN_0-1664951694410.pngManjunathKN_1-1664951720790.png

    you can filter the the view by filter line item.

    Thanks,
    Manjunath

Answers