comparison via set expression

[beck_bakytbek]

Hi Folks, my table does look like:

Cars, Damage, Cost of Damage

BMW, A, 5

BMW, B, 7

BMW, C, 10

AUDI, A, 12

AUID, B, 2

Porsche, A, 10

Porsche, B, 2

Porsche, C, 3

my question is: how can i show the cars that have more than 2 Damages and Cost of Damage (Average) more than 14 via set expression? I know i can solve it in script-area, but i would like to know how can it be solved in set expression.

Does anybody have any idea?

[rwunderlich · Accepted solution]

The set expression would be:

{<Cars={"=count(Damage)>2 and avg([Cost of Damage])>14"}>}

-Rob

[lironbaram]

hi 

this is an example for calculated dimension that will only show the relevant cars 

=aggr(only({<Cars={"=count(Damage)>2"}*{"=avg([Cost of Damage])>14"}>}Cars),Cars)

[beck_bakytbek]

Rob thanks a lot for your valuable time and your time

[beck_bakytbek]

Liron thanks a lot for your valueable time and your help