Forum Discussion

jteccampbell's avatar
jteccampbell
Frequent Visitor
9 years ago
Solved

Arithmetic across tables

I have a workbook with seven worksheets; each worksheet represents the same information just pulled from a different source. Worksheet one (the goal) and is what I want to compair all the other works...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago
    jteccampbell wrote:

    Unfortunately, no, I am blocked from uploading to OneDrive on my work network.  

     

    I get the following errors:

     

    Trying to creat relationships in BI:

    You can't create a relationship between these two columns becasue one of the columns must have unique values.

     

     

     

    jteccampbell,

    Please follow the guide in this similar thread to create relationship between your tables.

    Regards,
    Lydia

dtartaglia's avatar
dtartaglia
Resolver I
9 years ago

Hi,

 

Can you post to an FTP site? One work-around in Excel I've used is to create a new table using the UNION command. This assumes all the Excel tables have exacly the same columns (or at least using the same columns in BI). You may need to create a new column identifying the sheets.

jteccampbell's avatar
jteccampbell
Frequent Visitor
9 years ago

Unfortunately no, we are blocked from FTP sites on my work network.

 

I don't think the union command will work becasue to sums up items. I need to compair (for example) the number of bananas from tab 1 of my workbook to the actual numbers of bananas being reporting inthe other systems....not add them up. I need to be able to graphically represent that 'this is the amount of bananans we shoud have, this is the amount source 1 is reporting, and this is the varience".

 

Thanks for your reply