@prompt or User response

[former_member539471]

Hello All,

I have an object/db object "Status Percent". Now i need to display in my report 2 other objects "Current Status Percent" and "Previous Status Percent"
where....
Current Status Percent = Status of the year_month that was selected on the prompt page for current Quarter(Status of 201406 )

Previous Status Percent = Status of the year_month that was selected -3 months

SQL  ,  year_month user prompt/input

Current status: select status_percent where year_month = @userresponse(201406)

Previous status : select status_percent where year_month = @userresponse(201406) - 3 months

how should i be accomplishing this?

any inputs highly appreciated.

Thanks

[former_member190895]

You can create a OR condition in Query Filters in Web Intelligence.

[Former Member]

Hi Pali,

It wont be directly possible as you are filtering the data for ONLY 201406 in the query.

The query will not have data for 201403 to display.

You can try creating multiple queries or creating universe filters.

Regards,

Yuvraj