Year of Fiscal Quarter Year

[ruma_barman]

Hi All,

I need to show the year of last four fiscal quarter on selection of the current fiscal quarter selected.

A sample data is attached.

Kindly help.

Thanks and Regards,

Ruma

[Anil_Babu_Samineni]

You are not getting any reply means, No body is not working over here. Let me recommend who can offer you

hic

[ruma_barman]

stalwar1‌

Can you please reply on this?

Regards,

Ruma

[mohammadkhatimi]

Quarter4:

load

(fYear&Quarter) as TQuarter,

RowNo() as key,

sum(1) as TestSum

Group by fYear,Quarter

;

load

fYear,

Quarter

Resident Master_Calender

;

Final:

load

*,

if(key=1,null(),'Last4Quarter') as FourQuarter

Resident Quarter4 where key <= 5;

  drop Table Quarter4;

  drop Fields TestSum From Final;

Write above logic in your mastercalender and in frontend expression write below code:

=sum({<FourQuarter={'Last4Quarter'}>}Sales)

Hope this will helps...!!

Regards,

Mohammad

[sunny_talwar]

Where do you want this information? In an expression or text box object? What is the goal here... can you elaborate?