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

    Sales trend comparison of select Travel month


      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.