Forum Discussion

Newbie_77's avatar
Newbie_77
Frequent Visitor
7 years ago

Sum Rows from Different Tables, Deduct from Start Value

Hi All,   I'm sure this is really simple, searched and found similar but not the right answer.   I have 3 data source tables, combined into a BI table.  I need to add some totals plus deductions....
Need Help
Newbie_77's avatar
Newbie_77
Frequent Visitor
7 years ago

Hi, many thanks for your help on this.  still struggling !

 

3 images below show how it breaks at some point.   The Original merge shows the OrdersStart table (first table), merging with my Day1 table.  You'll notice that the OrdersStart is nice and simple, 10000 for 5 companies.  When merged by results in the second image and all still appears OK.  when then clicking the doible arrow and OK on next step, image 3 shows that the original Customer Start Values have duplicated - multiple Company 4 with 10000 each as a start value.

 

Am I doing something wrong ???

 

 

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If you look at my 2 pictures on my last reply, the data shows duplicate in the query editor but not in the visual within the report. If the duplcicates in the query editor concern you then I would do a remove duplicates before applying your changes.