2 Replies Latest reply: Jun 14, 2011 10:47 AM by Byron Van Wyk RSS

    An expression that IGNORES DIMENSIONS

    Byron Van Wyk

      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