Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 17, 2013 10:27 AM by
Using prompts as a filter
Apr 17, 2013 9:43 AM
I have reporting where I want to report the difference between amount from one year to another year.
I want to pass Year and Year as prompts And then use them to filter my amount column
So amount where year = prompt1 and amount where year = prompt2
and calculated item amount - amount
is this possible?
This content has been marked as final.
Show 1 reply
Re: Using prompts as a filter
Apr 17, 2013 10:27 AM
in response to
Accomdate the 2 filters with the presentation variables and then pass the same presentation variables to the column where you need to calculate the change between the 2 years...
mark if helpful/correct..