I have been asked to set targets for our sales, by customer and category. Each customer and category has a target and that needs to be divided over the 52 weeks of the year, based on last year. So for the combination customer 1 and category 1, week 1 has 1% of sales, week 2 has 3% of sales based on the sales of the combination customer 1 and category 1 for last year, week x has z% etc. For each customer/category combination I need to get to 100% over the year.
To find the weekly % of sales for 2019 for each customer/category combination I am using:
sum({<Year={2019}>}NNN_SO)/sum(total Aggr(Sum({$<Year={2019},Customer=,Category=>}NNN_SO), Customer,Category))
but this does not give me the % per customer/category, rather for all of them together. What am I missing?