perspective
perspective copied to clipboard
Filtering on aggregated results (similar to SQL HAVING clause)
Feature Request
Description of Problem:
Is there a way to filter on the aggregated results? For example after breaking down by Category and Sub-Category, I want to only display rows that have more than N Sales.
This is equivalent to this SQL:
SELECT "Category", "Sub-Category", SUM("Sales")
FROM T
GROUP BY "Category", "Sub-Category"
HAVING SUM("Sales") > N
### Tasks