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