Problem in Summation in different Table

building reports webintelligence
1

Hi All,

I need to show the SUM of two measure values corresponding to two different Dimension and in two different Tables, in the Thirs table.

Ex -

Table 1
Retail | Business
ABC | 200

Table 2
Banking | Business
EFG | 300

Table 3
Total Business
500

here we have to show the sum of Retail and Banking(i.e, 200+300=500) in the Table 3.

Any help will be really appreciated.

Thanks,
Shashank

Shashank_Shah (BOB member since 2011-06-11)

2

what is SUM([Business]) returning, is that the desired result?

jprasanthram :switzerland: (BOB member since 2010-12-10)

3

These two tables are two different table so SUM(Business) is not working. Business also inclued other entries. But here I have to show the sum of Retail and Banking only.

Can we use any InReport or InBlock funtion here?

Shashank_Shah (BOB member since 2011-06-11)

4

Then create 2 variables

var_Retail= Sum(If([Object] = “Retail”; [Business];0))

var_Banking= Sum(If([Object] = “Banking”; [Business];0))

use these 2 variables to display your Total Business.

jprasanthram :switzerland: (BOB member since 2010-12-10)

5

Or Try this-

=(Sum([Retail] ForAll ([Business]))+Sum([Banking] ForAll ([Business])))

Where Retail & Banking are measure objects and Banking is a dimension which has different values in the report and if you are putting any report level filter and you need that amount also in the calculation , you might need to use In Report also.

=(Sum([Retail] ForAll ([Business])) In Report+Sum([Banking] ForAll ([Business])) In Report)

aniketp :uk: (BOB member since 2007-10-05)