Filtering/Formula based Complexity



Had a query that i have been stuck on: - 

I have a module dimensioned by Projects, a List with serial numbers 1-10, list formatted Line item (Project Phase). 

Ask is, Projects dimensioned as row headers, Serial Numbers 1-10 as columns, Project phase/ Line Item as selector. End User can select a particular phase of the project and the table will only show projects of that phase while collapsing the others.

I tried bringing in a filter module, dimensioned by Phase, then referred the end user selection to the above module using look up attribute ? But it doesn't give the result, the system doesnt allow me to apply the said filter and while applying the filter i'm asked to either select a specific Project or specific Serial Number in the filter. 

Can someone help me with this or is there an alternative or better approach to this issue, thanks in advance