3 Replies Latest reply: Mar 14, 2014 9:49 PM by Srikanth P RSS

    Sum by Dimension Issue

    phillip colbert

      morning,

       

      having a nightmare this morning with a really simple problem.

       

      using an SAP schema, so all based around start and end dates.

       

      i have a straight table, with Age_Band as the dimension. The expression is built up of a concatenation of Day, Month and Year with a set expression to count the unique staff id's

       

      the total number calculated is correct, only instead of splitting up the value by the dimension i get the same top level value for each row in the dimension. Ie

       

      AgeHeadcount

      201000
      251000

       

      in the above example 1000 is the sum total, not the values for 20 and 25. i'm doing something stupid im sure.

       

      losing my mind!