@KonradAntczak … Hi Konrad.
You can use 2 calculated fields for calculate the two distinct fields in two columns of pivot table and then calculate the % among them, as other calculated field in the third column.
And you can see at right side two images or pivot tables , one grouped by dimension COUNTRY and PRODUCT_ID, and the other only grouped by COUNTRY, and %1 is correctly calculated in both.
Regards, José Burrull
Senior Data Engineer
ITVIS SPA. Santiago de Chile. 27.12.2023