I have a sales table with sales data for each retailer in the database. I know there is further granularity we can provide for certain retailers - I want to apportion these sales values to a lower level of granularity, based on the proportion of sales I can attribute to particular sales values
Existing table example:
Sales value (Eur)
I know retailer A can be split out into sub-values based on an apportionment provided by the business:
If the above one can't help you get the desired result, please provide more sample data in your tables (exclude sensitive data) with Textformat and your expected result with backend logic and special examples. It is better if you can share a simplifiedpbix file. You can refer the following link to upload the file to the community. Thank you.