Forum Discussion
Difficult Measures
Hi,
I'm struggling, from which i believe is a difficult measure?
We have four companies, two of them produces products and two trade companies will sell this products.
These trade companies can also buy products by third parties when needed.
Products are delivered directly at the customer, but it can als happen that products are stored in a warehouse.
From these warehouses products are sold, which were made by our self or buyed at third parties.
Now i have a saleslist from the four companies. I can see what is produced by our self, but i also want to calculate what is bought at third parties.
Is this possible with a measure?
Outcome will look like this:
| Source | 2017 | 2018 |
| Location A | 390 | 300 |
| Location B | 936 | 720 |
| Third Parties | 247 | 190 |
| Total | 1573 | 1210 |
is it also possible to show the price difference between 2017 and 2018?
Thank you in advance.
Kind regards
Marcel
Once again, I highly recommend against using the first visual solution I was able to create. I've created a 2nd matrix in the report that's a better way of working with the data, though still not as good as starting to record the source or adding in 3rd party orders to the original moving forward.
Here's the file: https://drive.google.com/open?id=16uxhevNcQQxO8gUSBclpupGBTHYDhpQV
11 Replies
- Hi Anonymous
A test file is in my post.
The original data which is in excel, is really big and contains sensitive data.
This data is also a little bit more complex to explain how everything works.
