Filters

  • It hides unwanted records (or) retrives wanted records by hiding unwanted recors
  •  

    Worksheet level: filter applicable to that particular sheet only.
    Data Source level: Filter applies to all the sheets using that data source.

     

    Worksheet level:
     Header level
     Data view level
     Using marks card
     Quick filter
     Context filters
     Cascading filter.

    CONTEXT FILTER: If we want to make one filter output depending on other filter we have to use context filter.

     

    Filters - Data source level

     

     

     

    Filters - Condition

     

  • AND Operator
  •  

     

    Filter on DIMENSIONS:

     

    Filter on MEASURES:

     

     

    Date Filters:

  • Relative Dates denotes specific Time
  •  

     

     

    Create TOPN Customers

     

     

    Result

     

     

    Data source level Filter

     

     

     

     

     

     

    Filtering Manual selection

     

     

     

     

     

     

    Filtering with WILDCARD CHARACTERS

     

    hi