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

    Sum by Dimension Issue

    Phil Colbert



      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





      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!