Hi,
I have ther requirement like if i select year and current quarter then it should display current Quarter and Previous quarter data.If the first quarter begins with Jan its fine i have used the calculations like(YEAR===(case
when((?quarter?)-1<=0) then((?year?)-1)
else((?year?))
end) and MONTH===case
when((?quarter?)-1<=0)
then(4)
else((?quarter?)-1)
end) but the problem is the financial year is starting with July Q1(Jul->Sep) how can i get the solution.
Please give me the update.
Thanks & Regards,
Babu.
Quote from: babu babu on 26 Apr 2010 07:24:01 AM
Hi,
I have ther requirement like if i select year and current quarter then it should display current Quarter and Previous quarter data.If the first quarter begins with Jan its fine i have used the calculations like(YEAR===(case
when((?quarter?)-1<=0) then((?year?)-1)
else((?year?))
end) and MONTH===case
when((?quarter?)-1<=0)
then(4)
else((?quarter?)-1)
end) but the problem is the financial year is starting with July Q1(Jul->Sep) how can i get the solution.
Please give me the update.
Thanks & Regards,
Babu.
Hi babu,
for this first u nedd to customize the Quarter taking another data item using case condition (like when [month] between 7 and 9 then 'Q1' else .....)based on this data item build your remaining condoition to get the Queraters based on the condition........
Hope it will helps u to have an difeerent idea of your own
Hi,
Are you basing this report on a Relational or a Dimensional package?
MF.
Hi I am using relational data only.I have created the new data item like case
when([build stats].[D_Build].[Month] in('Jul','Aug','Sep')) then('1')
when([build stats].[D_Build].[Month] in('Oct','Nov','Dec')) then('2')
when([build stats].[D_Build].[Month] in('Jan','Feb','Mar')) then('3')
when([build stats].[D_Build].[Month] in('Apr','May','Jun') )then('4')
END
but i am not getting the proper previous quarter data.
Please give me the update.Please can u give me the calculations for previous quarter
Thanks & Regards,
Babu.
Hi,
This is fine as far as it goes, but you need to bring the Year into your filter as well. For example, if you choose Quarter 2 of 2009, you would want to see the following months in your report:
Jul 2009, Aug 2009, Sep 2009, Oct 2009, Nov 2009, Dec 2009.
If you base your filter just on the quarter number (from the month name) you will end up with data for those months in all years.
MF.
Hi,
You might want to try the following approach in your filter:
if (?Qtr? = 4) then ([Year] = ?Yr?+1 and [Quarter] in (4,3)) else if (?Qtr? = 3) then (([Year] = ?Yr?+1 and [Quarter] = 3) or ([Year] = ?Yr? and [Quarter] = 2)) else if (?Qtr? = 1) then ([Year] = ?Yr? and [Quarter] in (1,4)) else ([Year] = ?Yr? and [Quarter] in (?Qtr?,?Qtr?-1))
To be able to subtract from the quarter values like this, you might also want to amend your Quarter calculation as follows:
when ([build stats].[D_Build].[Month] in ('Jul','Aug','Sep')) then (1)
when ([build stats].[D_Build].[Month] in ('Oct','Nov','Dec')) then (2)
when ([build stats].[D_Build].[Month] in ('Jan','Feb','Mar')) then (3)
when ([build stats].[D_Build].[Month] in ('Apr','May','Jun')) then (4)
else (0)
END
MF.