I have 3 different tables which have break on one variable and folded and there is a sum value
Now i was to have a field which takes the sum of the results of the 3 tables.
I just want a variable which add the results seen in the 3 tables.
How can I achieve it?
Thanks
Let me rephrase the Question I have 3 Tables there fore 3 blocks each table is bringing variables from 1 or 2 or 3 Data providers and there is a measure which is summed in the footer of the table
Now I want to add the summed up totals from these tables, there for my problem is adding variables across block numbers is it possible?
If its the same variable used in all three blocks, then display the variable either in another block or on the block footer of the third block
Use nofilter(<measure_obj>) function for the variable if there are any filters applied in those 3 blocks
filter is not the only thing which is different between the 3 tables the list of dimensions are different too.
So the summation of the same variable in 3 tables is different and i want addition of that.
Thanks
I will try to Give an example as iam not getting any help I think coz people are not understanding my problem
1 have 3 DP A B C
DP A has
AD1
AD2
AD3
AM1
ADV2(AD1)
ADV3 (AD1)
ADV4 (AD1)
What i mean is ADV2 is a detail of AD1 and is equal to AD2, I am doing this coz i have linked the DP on AD1 and BD1 and CD1
Similarly DP B has BD1 BD2 etc and C has CD1 CD2 CM1 etc
I have created 4 tables using measure M1 M2 and M3 and various filters on detail dimensions…
I now have Sum(AM1) Sum (BM1) Sum (Am1) Sum (Cm1) as 4 tables depending upon different filters on various dimensions from these 3 linked DPs
Is there a way I can sum Do sum(AM1) +Sum(AM1) +Sum(BM1) in the report
I guess you want to just add only the measures across all the 3 DPs (without any dimension or detail object in the total block)
Then have you tried it in a separate block as
The problem isnt as simple coz AM1 BM1 CM1 are all same only the context spans across 2 or 3 DPs
Let me try to put it another way
I have 3 tables 2 made from 2 DPs and one made from 3 DPs
I have a measure which is summed in all the 3 tables but the filters on all 3 tables are different.
Now i want to add the summed up measure in all the 3 tables.
How can I add them?
Let us suppose the sum of measure in table1=10
sum of measure in table 2 is 20 and sum of measure in table 3 is 30
I want the total to be seen as 60 in a cell, So far I have tried to ask this Question in various ways , but I am still stuck
(BOB member since 2005-07-18)