Two dimension pivot table and percentage

[#1]

I am trying to find percentage that percentage of sales of particular product out of total country sales

A - Country

B- Sales

I have used the following expression

aggr(sum(Sales),A,B)/aggr(sum(Sales),A)

Both of them are normal dimensions (not calculated)

I have attached excel of pivot the expression

[#2]

B is product type not sales

[#3 · Accepted solution]

Pivot table with two dimensions, calculation question