Duplication of rows

[ejgb]

I have two queries from seperate data sources;

Source 1

Field1 Field2
1 Fred
2 Chris
3 Matt

Source 2

Field1 Field2
1 1000
2 2550
3 5000

I have linked the two queries via Field 1. However, when I combine them in a table I get

Field1 Name Value
1 Fred 1000
1 1000
2 Chris 2500
2 2500
3 Matt 5000
3 5000

And the sum of the Field Value is correct at 8500.

Any suggestions.

Regards

Ed

 

[skrandel]

Change the formula for your measure to MultiCube(<your_measure>).

Steve Krandel
Intuit