set analysis on data island

[hopkinsc]

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

[Clever_Anjos]

Please try

Sum( {<Dimension=P(Dimension2)>} FullTotal)

[hopkinsc]

hi, thanks for the reply, that gives the same output unfortunately. 21500 on each line

[Clever_Anjos · Accepted solution]

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 ))

[Clever_Anjos]

Further reading A Primer on Set Analysis

[hopkinsc]

thanks very much, perfect

[Clever_Anjos]

Good to read that