How to compute Share to sub category using pivot

[bryan_21]

How to achieve computation using pivot table. Compute Share to Product Total using set analysis?

Sample like this:

[LRuCelver · Accepted solution]

Data:
NoConcatenate Load * Inline [
	ProductGroup, Product, Sold
    A, A1, 2
    B, B1, 1
    B, B2, 3
    C, C1, 2
    C, C2, 4
];

[bryan_21]

Thanks got it! I forgot that it should be with like this <>