how to convert a date prompt into a quarter when the user selects the date.The date should be converted into the querterly data and then i am supposed to calculate the 8 previous quarters data based on the selected date in the date prompt.
Hi,
Can u explain it more clearly?
-Dinesh
Below Expressions May Helpful to you..
case
when
extract(month,?p_date?) in (1,2,3)
then
'Q1'
when
extract(month,[Date Field]) in (4,5,6)
then
'Q2'
when
extract(month,[Date Field]) in (7,8,9)
then
'Q3'
else
'Q4'
end
And Based on the Quarter You can Go back and take the Previous 8 Qurters.
....etc