Hello
I hope you can help. Ive been searching for a bit but cannot seem to find my answer.
I have a excel table with many columns and rows. One of hte columns is LEAD_NAME. Another column is MEMBER_NAME. A lead can have more than one member in his team. (I am trying to figure out timesheets here)
I can see the pivot with all the data in which is good. However it is unmanagable so I wanted to have a report fiter for each LEAD_NAME. This makes it more managable but is still not ideal. Ideally I want to have a second report filter with just the values that are in MEMBER_NAME and not all values under the MEMBER_NAME column.
is this possible?
As an example
LEAD MEMBER TEAM MEMBER .... ADRIAN RICHARD ADRIAN SAM THOMAS THOMAS THOMAS JAMES BILLY JOEL
I have BILLY, THOMAS, ADRIAN as lead member. If I filter just on ADRIAN then I see only the rows with team mbmer containing RICHARD and SAM. What I want is anotehr report filter jsut contains RICHARD and SAM so I can filter even more. If I normally add another filter with TEAM MEMBER then I will show all TEAM MEMBERS - not just those related to the other filter's LEAD.
Hope this makes sense!
Is this possible?
Thanks
Bookmarks