Combining spreadsheet data

[former_member672670]

Hi Guys,

I have created 2 live office connections from 2 different Universes in Xcelsius. The Spreadsheet looks as shown below.

Connection 1:

Dept Name          No. of Projects

A                               1

B                               2

C                               3

Sum:                      6

Connection 2:

Dept Name          No. of Projects

A                               1

B                               2

C                               3

D                               4

Sum:                         10

There can be more/less rows from one connection as compared to the other.

Now, I would like to combine both spreadsheet data and represent them in a single pie chart.

Could anyone please help me achieve this?

[saurabh_sonawane · Accepted solution]

Hi

try to use a merge dimension in webi this can help you.

or in universe try to have a join.

[former_member672670 · Accepted solution]

Merging solved the problem. Thanks.