4 Replies Latest reply on Sep 7, 2016 3:21 AM by Anne-Sophie B

    Data not agregating at the right level

    Anne-Sophie B

      Hello

       

      I am working on a graph with data for 3 separate years. The 3 separate years are on 3 different data sources (excel sheets).

      My graph should display the average of a measure called DMS Vs a dimension called CMD, for each year.

      However the average is calculated correctly only for the year 2009. For the other years of data, 2010 and 2011, the average is calculated for the whole year and not agregated per CMD. The result is the average is calculated per CMD for 2009, but for 2010 and 2011 all CMD have the same average.

      I am not too sure of what is wrong here.

       

      Can anyone help?