Skip to Content
0
Former Member
Dec 30, 2011 at 06:48 AM

Calculating on data from two seperate blocks in WebI

55 Views

Dear All,

I have a report in which data from two separate blocks should be divided.

BLOCK 1

Dimension1 Dimension2 Measure1

1 a 100

2 b 200

SUM: 300

BLOCK 2

Dimension3 Measure2

a 500

b 500

SUM : 1000

Now my requirement is to divide 300/1000. FYI, Dimension2 and Dimension3 are merged dimensions.

And the two blocks are from two separate queries.

Thanks a lot in advance