Hello all,
I have one question, I have a calculation for WTD, QTD, Period To Date (PTD) and YTD in my report, I was able to get the calculation easily done for WTD, QTD and YTD. where I am struggling to get the data correct for Period To Date calculation, which is nothing but Month To Date. If I pass Week as parameter in PTD calculation, I have to display days for that month only on the x-axis.
Example: if I select fiscal week i.e. 01/18/2014 in the prompt at run time then report on x-axis should display all the days each day on x-axis from 01/18/2015 to 01/01/2014.
I tried creating calculation like below.
periodsToDate ([MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Month], [MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Week]->?p_fiscal_week?)
But it is not working as expected, can you please help me on it.
Example: Calculation used for QTD looks like below
periodsToDate ([MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Quarter], [MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Week]->?p_fiscal_week?)
WTD, QTD and YTD calculations are working as expected.
Your help is much appreciated
Thanks & Regards,
Xyz