Could you please help me with the set of Queries to find the year on Year, Quarter on Quarter change of Revenue if the Financial Year starts from April.
1. I have the dataset from FY14.
2. Need to calculate the chnage of revenue from FY14 - FY15, FY-15-FY16 etc..
3. Need to Calculate the chnage of revenue from FY14-Q1 to FY14-Q2, FY14Q2 to FY14Q3 etc.... till FY19Q3 Till date.
Also please let me know if the above calculation is different from YTD, QTD REvenue.?
PLease let me know if you need a sample data.
Appreciate your help this is an immediate requiremt for me.
Solved! Go to Solution.
Thanks for your file, could not get the result since i need to get the change every quarter and month.
With the same idealogy , tried with my Dataset but still could not get the result.
Appreciate if you could help me.