Oracle Business Intelligence

Products Banner

Reg: Bar Graph for TopN and rest of the values

Received Response

Hi Everyone,

As we have no. of sales in vertical axis and rank of the regions in horizontal axis we have to plot the Bar graph. There will be prompt for dynamically selecting the TopN ranks of regions, if we select Top10/15/20 in the prompt it as to show all top 10/15/20 ranks of the regions with respect to sales and at last remaining leftover data as to be shown as 1 bar/ bucket.

Can anyone suggest on this.

OBI Version we are using:




  • Graph should looks like as above in the prompt we will select top range and rest of the items should show like this.

    Using presentation variable we till selecting top N range we did, and for showing rest of the items can anyone suggest on this how to achieve.

    Thanks in Advance,