Divide a Total Brand Tax by SKU weighted by sales ammount

[DiegoPerez85]

Hi! I have a table with sales by year and sku and in a related table a tax ammount dividide by brand and year. I want to assign for each sku the correspondent part of the tax weighted by the sales ammount of the SKU. How should I formulate the calculated column?

Thanks!!

Diego

[v-qiuyu-msft]

Hi @DiegoPerez85,

Can you share the sample data about this two tables and expected column values for our analysis?

Best Regards,
Qiuyun Yu

[DiegoPerez85 · Accepted solution]

Hi @v-qiuyu-msft. I just solved this. I'm closing the thread. Many thanks for your reply!