Clarification on Filters: I applied the filter with AND and OR conditions, and it worked. However, finding the correct condition is complicated and requires multiple attempts. It would be great if this process could be simplified, similar to Excel filters.
Issue with Basic Filter: Have you checked with the Test 4, When applying a basic filter to more than one column, the result seems incorrect. Here’s an example applied in the video:
Test 4 - Basic Filter
- Assigned to: Vivian
- Result: 152 (Correct)
Additional Filter Applied:
- Level: Blank
- Expected Result: 123 (152 - 29)
- Actual Result: 141
The expected result should be 123, not 141.