Current Fiscal Year Current Quarter vs Previous Fiscal Year Same Quarter

[#1]

Hi All,

I need Current Fiscal Year Current Quarter vs  Previous FiscalYear Same Quarter. Can any one help me or send me a sample application.

Any help would be appreciated.

Regards

Deepak

[jagan]

Hi Deepak,

If you have a date field then try like this

Current Quarter:

=Sum({<DateFieldName={'>=$(=QuarterStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)

Previous year Current Quarter:

=Sum({<DateFieldName={'>=$(=QuarterStart(Max(DateFieldName), -4))<=$(=QuarterEnd(Max(DateFieldName), -4))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

Thanks for Reply,it working for Current Year but in  Case of Previous Year Same Quarter it showing the same Value as the Current Year Quarter.

Regards

Deepak

[Sokkorn]

Hi Deepak,

Maybe here, here and here can help you to figure out.

Regards,

Sokkorn

[jagan]

Hi,

Exclude the date filters in the dashboard within the expression as below

Current Quarter:

=Sum({<YearFieldName=, MonthFieldName=, QuarterFieldName=, WeekFieldName=, DateFieldName={'>=$(=QuarterStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)

Previous year Current Quarter:

=Sum({<YearFieldName=, MonthFieldName=, QuarterFieldName=, WeekFieldName=,DateFieldName={'>=$(=QuarterStart(Max(DateFieldName), -4))<=$(=QuarterEnd(Max(DateFieldName), -4))'}>} Sales)

Hope this will the issue.

Regards,

Jagan.