Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating value based on columns in two different tables

Hi - Newbie question...   I've searched hard for a solution to this question and have tried several different ideas but keep getting an error message or values that do not make sense. I have two ...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    You would propose that you extract the product/item object into its own dimension table, which then feeds the inventory and backorder fact tables with a unique address of 1:* each.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi everyone, 

I need help with solving one problem. 

Take a look at this demo table: 

 

 

We have 4 different columns, one is "client", the second one is "transporter". Some of our clients are also and transporter. 
I want to make a mutual column and summarize money we earn cooperating with that client ( sum of SUM EUR) - Looking column "client" and "SUM EUR" column, and looking the "Transport" column and the column "price to transporter". 

I want to see how much money we give to transporters and how much they give us as a client we work for. 

For example, "client 8" as a client gives us 420€, but we give "client 8" as a transporter 300€. 

I just want to compare these two values with mutual clients I have in column "client" and column "Transporter". 

Thanks in advance.