6 Replies Latest reply: Sep 10, 2013 7:53 AM by Ekugbere Esemiteye RSS

    How to compare year by year

      Hi,

       

      i have trying to compare two different years, i have a dimension called

      DateArrived:

      LOAD  [BLD Ref],

           Source,

           Registration,

           [Model/Make],

           CC,

            date([Date Bike Arrived]) as [Date Arrived],

            Date(MonthStart([Date Bike Arrived]),'MMM-YYYY') as [Arrived MonthYear],

            year([Date Bike Arrived]) as [Arrived Year],

        Month([Date Bike Arrived]) as [Arrived Month],

        1 as ArrivedCount

      FROM

      Tier2_QVDs\DateArrived.qvd

      (qvd);

       

      my aim is to compare betweeen two months or year (arrive count), how many bikes came in ( i can do that in a single table)

      but need to compare by year or month on a chat? and is it posible to add a second dimension like repair to it