Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combining spreadsheet data

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?

Former Member
Former Member replied

Hi

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

or in universe try to have a join.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question