locked
How to filter Choice column. RRS feed

  • Question

  • I have three columns which are choice those are

    1. project

    2. Team

    3. PM

    I have to compare these three columns with all the choice in "Project ", one choice in " Team" and Two choice in "PM"

    I tried below filter steps

        Project

    or

        Project   

    or

        project

    and

        Team

    and

        Pm

    or

        pm

    In this way its not working out, Its taking one "PM" only and displaying all the items under Last PM.  Can any one have any solutions.

     
    Thursday, December 8, 2016 10:52 PM

All replies

  • Hi

    i recommend you a calculated columnlike this - the values can be changed based on your needs

    For Project = 100

    TM=10

    Team = 1

    So for an item with

    Col1      Col2        Col3             Calculated

    Project        Team      Team            102

    Project         TM            TM               120

    TM                Project      TM             120

    TM             Team         Project         110

    You can now order based on numeric Calculetd column     


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Monday, December 19, 2016 2:07 PM