This content has been marked as final. Show 3 replies
I have 2 prompts year and quarter
in the report i have 4 measures measureA,B,C,D
i kept that mearure labels in row level..
A,B,C,D will come one by one...
my req is..when user selects year as 2012 and quarter as Q2
the respective 4 measures should display values relate to that quarter only..
below that 4 measures again i need another 4 measures like above..
but values should come for remaining two quarters..i.e Q3 and Q4.
can any one help
Edited by: Bhargav K on Dec 5, 2012 10:30 AM
You need a Quarter Number column in the prompt which shows values like 1 , 2 ,3 4 .
Then you set presentation variables Pv_Year and Pv_Qtr using the prompts.
Next you will create a union report as
A B C D
filter Year equal to Pv_Year and Quarter Number equal to Pv_Qtr
A B C D
Filter Year equal to Pv_Year and Quarter Number is greater than Pv_Qtr
Hope this helps