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
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!!
I have found several resources that will surely help you nail down your query:
Let me know how it goes or if you need further support