How to get the YTD Chart correct and the "PY Actual" calculation correct?

[suvechha_b]

Hi All ,

My Requirement is , I have to build report depending on the snapshot. Please verify if , my YTD chart is correct ?

My PY Actual expression is not working correctly .

Please find the sample model attached.

[kaushiknsolanki]

Hi,

Change your vPrevFiscalYear variable to

=Max([Fiscal Year])-1

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

What you are trying for Current Year, As you said it's working good

Can you share the expression? And then, we might offer you to get PY

[suvechha_b]

But , there is a possibility that I have to load for [Fiscal Year] 2014 until 2017 .

Thus , when I select 2015 , the report should work.

[kaushiknsolanki · Accepted solution]

Hi,

The Max works with selection, so when you select 2015, the Max function will give 2015 as result and then the variable will give  2014 as result.

Regards,

Kaushik Solanki

[suvechha_b]

Sum(Aggr(if(Measure='Quantity',SUM({<[Fiscal Year]={$(vPrevFiscalYear)},[Type Indicator] = {'A'} >} Quantity),if(Measure='Value',SUM({<[Fiscal Year]={$(vPrevFiscalYear)},[Type Indicator] = {'A'} >} [Sales Value]),if(Measure='AIMS Units',SUM({<[Fiscal Year]={$(vPrevFiscalYear)},[Type Indicator] = {'AIMS_SALES'} >} [Quantity]),SUM({<[Fiscal Year]={$(vPrevFiscalYear)},[Type Indicator] = {'AIMS_SALES'} >} [Sales Value])))),Measure))

My CurrectYear is what, I select in the filter and PY should be Select Year -1.

[suvechha_b]

Please can you verify , if my YTD Report expression are correct.

[Anil_Babu_Samineni]

What does this vPrevFiscalYear???