Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have quarteryear fields as dimension and below are my expression
1.QuarterOnQuarterSale
fabs(sum({<FiscalYear={">$(vFY)"},[Date]={">=$(=YearStart(min({$<FiscalYear={$(=min(FiscalYear))}>}[Date]),0,4))<=$($(vQY))"}>}[Amount])/100000)
2.Growth of all Quarter
((fabs(Sum(Amount))-above(fabs(Sum(Amount)),4))/above(fabs(Sum(Amount)),4)) * 100
Variable values
vFY=Year(addyears(max([Date]),-4))
vQY=QuarterStart(Today())
I almost done with my requirement but I don't want below highlight growth line for Q1 11 to Q4 12
PFA....
Thanks
There are two ways to do this:
1)
((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100 *
Avg({<FiscalYear={">$(vFY)"},[PostingDate]={">=$(=YearStart(min({$<FiscalYear={$(=min(FiscalYear))}>}[PostingDate]),0,4))<=$($(vQY))"}>} 1)
2)
If([Sales] > 0, ((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100)
I suggest option 1, but option 2 is available in the chart as well
Would you be able to provide a sample to work with?
After open please do clear all
There are two ways to do this:
1)
((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100 *
Avg({<FiscalYear={">$(vFY)"},[PostingDate]={">=$(=YearStart(min({$<FiscalYear={$(=min(FiscalYear))}>}[PostingDate]),0,4))<=$($(vQY))"}>} 1)
2)
If([Sales] > 0, ((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100)
I suggest option 1, but option 2 is available in the chart as well
Thanks Sunny
I really appreciate your help...
Can you please tell how can I achieve YoY chart like attachment .
Many Thanks
This?
=Sum(GL_Amount/1000) - Below(Sum(GL_Amount)/1000)
Hi Sunny,
Thanks for your quick reply.
I need data for only five years.
Thanks
But I wonder if the numbers make sense?
Can you elaborate on what you are looking for? May be expected output in an Excel file?