Explanation

Advanced filtering allows you to extract records based on multiple criteria.

Example

Find:

  • Sales from Sirsa
  • Sales greater than ₹10,000
  • Product = Laptop

Key Concepts

  • Multiple criteria
  • AND conditions
  • OR conditions
  • Advanced Filter
  • Filter to another location

Practice

Create a filtered report containing only customers whose:

  • City = Sirsa
  • Sales > ₹10,000