Set Analysis on dimension

[sagnikrana]

Hello everyone,

I am trying to select those projects, whose sum of revenues are between a range (vRevenueMin, vRevenueMax)

I have tried the below equation,  but is not working for me.

aggr(ONLY({<AGGR(SUM(RevenueAmount), project_name) = {">=$(vRevenueMin)<=$(vRevenueMax)"}>}project_name),project_name)

project_name, RevenueAmount

A, 100

A, 70

B, 30

C, 10

I appreciate your help!