Qtrs & total Help

[#1]

Hi All,

Actually my fiscal year will start from november.

I have one table which shows values as Number and Percentage.

I have one column Qtr which contains last 4 completed quarters (2015Q3,2015Q2,2015Q1,2014Q4).

If user didn't select any value from this table then table should show data for last completed Quarter(2015Q3 in our case) and last year equalent quarter(2014Q3) and If user select anyone from'Qtr' field then it should display selected quarter and same equalent quarter from previous year.

Here i hardcoded quarter values and user clear all selections it should show data for Last completed Qtr and same equalent Qtr from Previous Year( in our case it is 2015Q3,2014Q3).

And present Percentage value is distributed based on quarter Ex: for 2014Q3 50%,2015Q3 50%. But i want to display 100% in both quarters for Category 'A' and for Category 'B' it is 20% in both quarters(this should applicable for all Categories)

Could you please anybody take a look into this?

Thanks,

[#2]

Hi Guys,

Any Ideas?

Small help also useful for me. It's an urgent thing,

Thanks

[#3]

Could you please somebody help me here?

[Kushal_Chawda]

In front end you have FQtr but in Expression you are using Quarter.. Why it is so?

[#5]

Hi Kush,

Thanks for reply.

Actually my requirement is user want to see last 4 quarters only if he click on one of this quarter then it should get same equivalent quarter from previous year.

Thanks in advance