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