Previous Quarter Report

[babu babu]

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.

[Sreeni P]

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

[MFGF]

Hi,

Are you basing this report on a Relational or a Dimensional package?

MF.

[babu babu]

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.

[MFGF]

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.

[MFGF]

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.