Growth line for three years

[prma7799]

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

[sunny_talwar]

Would you be able to provide a sample to work with?

[prma7799]

stalwar1‌

After open please do clear all

[sunny_talwar · Accepted solution]

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

[prma7799]

Thanks Sunny

I really appreciate your help...

Can you please tell how can I achieve YoY chart like attachment .

Many Thanks

[sunny_talwar]

This?

=Sum(GL_Amount/1000) - Below(Sum(GL_Amount)/1000)

[prma7799]

Hi Sunny,

Thanks for your quick reply.

I need data for only five years.

Thanks

[sunny_talwar]

But I wonder if the numbers make sense?

[prma7799]

Hi stalwar1‌,

Like above I need to show only five year of data with growth.

Thanks

[sunny_talwar]

Can you elaborate on what you are looking for? May be expected output in an Excel file?