Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The set expression would be:
{<Cars={"=count(Damage)>2 and avg([Cost of Damage])>14"}>}
-Rob
The set expression would be:
{<Cars={"=count(Damage)>2 and avg([Cost of Damage])>14"}>}
-Rob
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)
Rob thanks a lot for your valuable time and your time
Liron thanks a lot for your valueable time and your help