Comparing two aggr values and showing only if it the condition is met

[#1]

I need to compare two aggr values, to see if one group (ANTS) is greater sales than any of the other groups( BEES, FLIES, MICE)

Dimension:

Date

Group

Stores

Metric (Load if Group = ANTS sales are greater than ANY GROUP)

MIN(aggr(sum({<GROUP={'ANTS'} >}SALES),Date,Group,Stores))  > MIN(aggr(sum(SALES),DATE,Group,Stores)

I'm using a chart and I'm getting an empty chart.

[ahaahaaha]

Hi Rolando,

May be like this

=RangeMax(aggr(sum({<GROUP={'ANTS'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'BEES'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'FLIES'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'MICE'} >}SALES),Date,Group,Stores))

Regards,

Andrey

[#3]

Andrey,

There is another dimension called Items and  I need to compare the lowest priced item in group ANTS to see if its greater than any of the lowest priced item in the other group.

Thanks in advance,

Rolando