SOLVED

Help with Power Query to calculate the % sales contribution in units at a model/seg/Brand

Contributor
Hi All,

Hope you are doing well!..I am trying to calculate the percentage contribution of sales for different vendors for a unique combination of segment, model and Brand for different vendors...Please find attached the file with the input and the expected output ...Can you please help me here..


Thanks,
Arun
2 Replies
best response confirmed by Arun Chandramouli (Contributor)
Solution

@Arun Chandramouli Regular pivot table could do it.

See attached.