But when i convert it into a pivot table, the percentage and sales are coming correctly at the product level, but the totals are not summing up at market and country level.
I tried using dimensionality, but showing incorrect results.
Doing Aggr and Sum is also not working.
Can someone help me to achieve this in Pivot table ?