Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, i have a data island that contains a key field, the same key field exists in another island-named differently (i do not want them to link).
the data in one table has been reduced and the data in the island holds the full data set.
i have a straight table that i want the reduced data value of field A to show against the full data set of the same field value in the island, if that makes sense.
example.
ReducedTable
Dimension,ReducedTotal
NameA, 100
NameB, 50
NameC, 200
FullTable - Data Island
Dimension2, FullTotal
NameA, 1000
NameB, 500
NameC, 20000
at the moment the result of the straight table is..
Dimension ReducedTota FullTotal
NameA 100 21500
NameB 50 21500
NameC 200 21500
this is obviously because there is no link between the tables (which is correct)
The result i want is..
Dimension ReducedTotal FullTotal
NameA 100 1000
NameB 50 500
NameC 200 20000
Can anyone help to achieve this?
i have tried the simple way of
Sum{<Dimension=Dimension2>}FullTotal
any help would be appreciated
example attached
Checking your app, you need that Dimension2 corresponds to the Dimension1 aggregation of graph? It´s not possible using Set Analysis,
Set Analsys cube expansion is calculated before the aggregation of the graph
you need this
SUM( if ( Dimension = Dimension2, FullTotal ))
Please try
Sum( {<Dimension=P(Dimension2)>} FullTotal)
hi, thanks for the reply, that gives the same output unfortunately. 21500 on each line
Checking your app, you need that Dimension2 corresponds to the Dimension1 aggregation of graph? It´s not possible using Set Analysis,
Set Analsys cube expansion is calculated before the aggregation of the graph
you need this
SUM( if ( Dimension = Dimension2, FullTotal ))
Further reading A Primer on Set Analysis
thanks very much, perfect
Good to read that