Aggregate Value Bucketing Across Levels

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error ‘Aggregation dimension sum cannot be used together with a dimension input’