Restrict data for Graph based on prompt

[former_member245931]

I have a below requirement to build the graph in Webi

User selects a input control for  Year or Region

If the selection is Year

Then data should display for all the years and all the regions, where year in x axis and revenue as data (Pic 2)

If the selection is Region

Then data should display for latest year and all the regions, where Region in x axis and revenue in Data (Pic 1) in the same graph

I am able to achieve the first one but when a region is selected how to filter the graph only for latest year ( created variable to get the latest year)

Is it possible to apply filter on graph based on a variable.

[nikhil_joy2]

Hello,

Refer below link where a similar logic has been implemented. You can use the same idea to achieve your requirement.

http://wiki.scn.sap.com/wiki/display/BOBJ/Creating+a+dynamic+report+using+Input+Controls

Also a similar logic in below link.

http://scn.sap.com/message/15192928#15192928

hope it helps.

Regards,

Nikhil Joy

[gleo_SRAM]

Consider two graphs as you have above.

Use the Hide when the following formula is true.  Add an IF statement to say if Year > 0 then show the Year Graph and Hide Region graph and visa versa.

The relative position of the graphs will be the exact same place - but only one can be displayed at a time. The different graph displays will be seamless to the user.

With regards

Gill