5 Replies Latest reply on Jan 11, 2017 9:14 PM by Shinichiro Murakami

    Sales trend comparison of select Travel month

    YIXI ZHANG

      I need to create a report to show the sales trend year on year comparison of selected travel month;

       

      The data set is Airlines sales ticket data, the field used in this report include: 'Sales date'; 'Travel date' and 'PaxNo'.

       

      The business logic: Any flights will be selling up to one year advance maximum, for example, the flight on 01 Oct 2016, the earliest sale date would start from 01 Oct 2015(included).

       

      What I need to do is making the two year's sales trend starting from a same point and compare them in the same time scale.