Power Query or Pivot to get distinct values and sum of values in another column

Hello

In sample attached, I have created a pivot table from summary table but '% of Total Holdings total do not match. How do I resolve this

If this can be in power query also I am ok with it