Re: How to show the growth% in YTD/QTD/MTD in Pivot table?
I tried using above function, it fails because,
YTD - It calculates, growth% with this year with the previous whole year instead of calculating this year with previous year till date.
QTD and MTD - It calculates, growth% with current Quarter/Month with Previous Quarter/Month but the requirement is to calculate using current year current Month/Quarter with previous year same Quarter/Month.
In the attached app, I tried to calculate growth% for the fiscal quarter and month it is working fine. But I swap the fiscal year as the first dimension in the pivot table calculation doesn't work correctly.
Thanks in advance..!! and kindly excuse my delayed reply.