An expression that IGNORES DIMENSIONS

[#1]

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

[matt_crowther · Accepted solution]

try:

=min(total <BusinessUnit> Cost)

Works for me.

Matt - Visual Analytics Ltd

[#3]

Perfect

I tried aggr but it didnt show me values for the rest of the fields

Thanks a lot Matt

Cheers,

Byron