2 Replies Latest reply: Jun 25, 2013 7:20 AM by Nikki Fairgrieve RSS

    Month Calculated Dimension

      Hi,

       

      I have a table similar to this:

       

      SiteMonthYear Units
      East LintonJan130
      East LintonFeb130
      East LintonMar1317
      East LintonApr

      13

      15

       

       

      What I need to calculate is the Total No of Units - 32 and the  Month where the the first units were sold - Mar 13. I need to create a chart that will look as follows:

       

      SiteMonth of PurchaseUnits Sold
      East LintonMar 1332

       

      I have Site as a Dimesion. The calculation for units sold is, this works fine:

       

      sum(Aggr(DISTINCT $(vUnitsSold),Site))

       

      However I am sturggling to work out the Calculated Dimension to give me the Month where Units <> 0 and Month = Min(Month) where a value exists?

       

      Any help appreciated.

       

      Thanks,

      Nikki