Cannot solve problem: how to FILTER on Subtotals per category
I have data on payments over 2 yr period.
Payments have categories such as grocerries, car, insurance, pharmacy, etc.etc.
I used default domo vizualizer to visualize total costs(Y-axis), BY YEAR (X-axis) using STACKED charts.
when I click within a stack, a specific category lights up - NICE.
Problem: There are over 100 categories, and many are irrelelvant. I just want to visualize top categories where subtaotal WITHIN category is above specific dollar value (e.g. $1,000). IOW, I want to batch exclude all categories of purchases where subtotal/category is less than $1,000.
How do I do that?
In attached pic, these irrelevant categories, are displayed as thin lines.
When I try to filter by value, and set "min" value of $1,000 the app looks for individual transactions, as opposed to AGGREGATE sums within a category.