11 Replies Latest reply: May 15, 2016 12:38 AM by Prasanta Kumar RSS

    Master calendar

    Prasanta Kumar

      hi,

      I am trying to create a master calendar which will help me to create a chart for a complete year even if i miss with data for a month.

       

      my month start from Nov of every year.

       

      and my order date column is in a format like "YYYYMM", for ex for nov'16 it is like 201611.

       

      can you please guide me how to create a master calendar for below information

       

      Fiscal year (format FY16)

      Fiscal Quarter (format Q1)

      month format (Nov)

       

      I have gone through some of the earlier post, but so far not able to achieve this.

       

       

       

      thanks

      Prasanta

       

      mto