1 Reply Latest reply on Nov 23, 2016 4:24 AM by lenaic.ridinger

    QoQ/MoM including Partial Quarter and Month

    sri.ram.4

      Hi,

      I have the following requirement

       

      I need to build a view for QoQ/MoM - Current Year 2016 Quarter/Month vs Previous Year 2015 Quarter/Month the catch is should include the given partial quarter (or) Month I need to calculate the exact current dates vs previous year dates

      Example :

      With year selector = 2016 it should calcuate QoQ and MoM including partial Quarter and Month there will be two View for Quarter and Month

      1. Month is partial with Partial Oct month (29 days)  these current dates should compare with previous Q4 2015 with Oct month (29 days)

      2. Quarter is partial with Partial Current Q4 vs same time period of previous partial Q4 2015

       

      Any help is highly appreciated!! Thanks!!