Soldato
Hi all,
I'm really struggling with this as I'm not that great with PowerQuery and I think this will require something more advanced.
Essentially - I have two reports, one with total sales and one with products split out. There is "masked" data when the product is split, i.e. the total sales from the product split doesn't add up to the total sales.
Therefore I want to:
![](https://i.ibb.co/2nCnjDZ/1.png)
Total
![](https://i.ibb.co/4Fshry9/2.png)
Does anyone know how I would go about this?
I'm really struggling with this as I'm not that great with PowerQuery and I think this will require something more advanced.
Essentially - I have two reports, one with total sales and one with products split out. There is "masked" data when the product is split, i.e. the total sales from the product split doesn't add up to the total sales.
Therefore I want to:
- Compare the sales for the month from product split, to the total sales for the month - to find the difference
- Add the difference into the sales split table/query e.g. in the below example, it will return 50 for Jan, Feb, March and so on (as that's the difference between the roll up and the total)
![](https://i.ibb.co/2nCnjDZ/1.png)
Total
![](https://i.ibb.co/4Fshry9/2.png)
Does anyone know how I would go about this?