8 Replies Latest reply on Apr 21, 2018 6:14 AM by Arnab Chaudhury

    Different Fiscal start month for different countries

    Arnab Chaudhury

      Hello Experts,

       

      I have a requirement in which different countries have different fiscal start month. The need is to start the axis from the fiscal start month rather than the usual month "January". Also, I need have a drill down and up capability on it.

       

      So for example for country China the fiscal start month is June. So the line chart axis must start from June and if I drill up, Q1 should start from June i.e. Q1(June to August), Q2 (September to November), Q3(December to Feb), Q4 (March to May)

       

      Please see attached workbook and mock data.

       

      Thanks in advance!!