Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys and gals,
I have table that say has 4 dimensions and then a sum(value) field. I want to create an expression that will give me the min value for dimension 2 and ignore the other 2 further down dimensions that gives my table more granularity.
So to illustrate
D1: Person D2: BusinessUnit D3: Cost Expression: min(Value by D2)
a 1 500 50
b 1 1000 50
c 2 400 400
d 3 300 300
e 4 200 200
f 1 50 50
g 2 2000 400
How do i achieve this with a min expression
Thanks,
Byron
try:
=min(total <BusinessUnit> Cost)
Works for me.
Matt - Visual Analytics Ltd
try:
=min(total <BusinessUnit> Cost)
Works for me.
Matt - Visual Analytics Ltd
Perfect
I tried aggr but it didnt show me values for the rest of the fields
Thanks a lot Matt
Cheers,
Byron