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

[Arun Chandramouli]

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 · Accepted solution]

@Arun Chandramouli Regular pivot table could do it.

See attached.

[#3]

Thanks @Riny_van_Eekelen !...I just discovered that capability!..