Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
PWA 2007, Filtering Project Center views

Answered PWA 2007, Filtering Project Center views

  • Thursday, June 24, 2010 8:03 PM
     
     
    Sign In to Vote
    0

    Hi,

    I need to apply this filter to a project center view:

    (stage = planned or stage = active) and (category = A or category = B)

    "stage" and "category" are custom fields

    I add this filter to the view:

    stage equals planned or

    stage equals active and

    category equals A or

    category equals B

     

    but I still see projects in the view that don´t fullfill both conditions (stage and category)

    Is there any way to apply both category and stage conditions to the filters?

    Thanks, Patricia

     

     

All Replies

  • Thursday, June 24, 2010 9:13 PM
    Moderator
     
     
    Sign In to Vote
    0
    Working without Project Center in front of me....you may have to try:
     
    Stage equals planned AND category equals A OR
    Stage equals planned AND Category equals B OR
    Stage equals Active AND Category equals A OR
    Stage equals Active AND Category equals B
     
    A bit tedious, but doable.
     
    - Andrew Lavinsky
     
    > stage equals planned or
    > stage equals active and
    > category equals A or
    > category equals B
     
     
     
  • Friday, June 25, 2010 6:39 PM
     
     Answered
    Sign In to Vote
    0

    Thanks Andrew, I tried but it didn't work, the view doesn't show some category B and planned projects. :-(

    I tried another way... I created two new custom fields with formulas:

    stageFilter: "yes" if stage = planned or stage = active

    categoryFilter: "yes" if category = A or category = B

    and then I changed the view filter: stageFilter = yes and categoryFilter = yes

    I think perhaps it's not the best, but it worked

     

    Patricia