Forum Discussion
Sum Rows from Different Tables, Deduct from Start Value
Then either we are doing something a little bit differently in our examples or I'm not understanding yourdesired results. I added a duplicate value for project 12345 in Table2 with a Value Day 1 of 1000:
in my output visuals i have all values set to not summarize. You'll see that I only have one entry in table2 for project 12345 with a value day 1 of 1000 (not 2000). In my merge1 table it used the 1000 in value day 1 and 2 to calculate my end value (10000 - 1000 - 1000 = 8000). What am I missing?
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 ???
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.
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.
Hi, sorry to bother you again. Really trying to sort this for my boss !
Can you have a look at the excel file stored in this drive link and see if you can replicate the required output ? (possibly sending back the pbix so that I can see how its done). You'll notice that multiple items for the same project will have a 'Price' in column R for Day 1 and Day 2. This data represents that multiple items were delivered to the customer on that day and the original project start value will reduce. Everything starts at 10000, but this figure seems to multiply once the day 1 and day 2 are merged in.
https://drive.google.com/open?id=1HQmANpuSYg25ptWc2utDZWNyVuxaTkBt
I'm really grateful for the help and advice.
Phil.
I can but do me a couple of favors. There are a lot of extra columns in there that aren't part of the merging we're trying to do. Please delete them so I don't get mixed up. Also, replicate the expected output in a separate worksheet. Then reports the file and I'll take a look.