one dimension and two fact report in OBIEE

717606

Dear All,

I have one dimension "region" and two facts (Sales value & Gross margin%). Gross margin% is logical column which has been derived from two other facts column and it's value is in range from Zero to 100.

Now, I want to generate below report. For each gross margin% range of 5%, I want to sum the sales value for each region. Please assist (Just a small snapshot of report)

GM% Region_1 Region_2
<0 254 619
0-0.05 524 799

Thanks & Regards,
[email protected]

NareshMeda

Hi,

Create Bins for Gross% fact column and go to pivot view place Gross% fact column into rows area,region column into columns section and sales value into measures section

hope it works