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