Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are not getting any reply means, No body is not working over here. Let me recommend who can offer you
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
Where do you want this information? In an expression or text box object? What is the goal here... can you elaborate?