Calculating total in dimension

[#1]

I am attempting to use this calculation in my dimension but it is not working:

if(sum(total <PROD_DT, REL_CD> VALUE) > 10000000, REL_CD))

What I m trying to do is calculate a sum of 'VALUE' for each 'REL_CD' on a given 'PROD_DT' and only display that 'REL_CD' in the dimension if it's sum is greater than 10 million. Does anyone know why this is not working and if there is a way to successfully accomplish what I need?

Thank you

[sunny_talwar · Accepted solution]

Try this:

=If(Aggr(Sum(TOTAL <PROD_DT, REL_CD> VALUE), REL_CD) > 10000000, REL_CD))