Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data is not coming properly for two axis chart...

Dear All.

I want to apply the thisyear expression in given chart with growth but the data is not coming properly...

PFA

Thanks

1 Reply
Gysbert_Wassenaar

=(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000) / (Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}

,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}

>}Values )/10000000)-1


talk is cheap, supply exceeds demand