Different measures depending if the pivot table is collapsed (market share)

[julioarriaga]

Hi, community,

I need something as the image below where I can see in a single column the market share per Region, and then the market share of the country (Pais) in its corresponding region.

I have tried with the Dimension() function and some way of identifying if the field is collapsed, to no avail. 

As always, thank you for the help, and kind regards.

[chrismarlow · Accepted solution]

Hi,

When you say you have tried 'Dimension' function, do you mean the following does not work;

if(Dimensionality()=1,sum(Total <Region> Monto)/sum(total Monto),sum(Monto)/sum(total <Region> Monto))

Cheers,

Chris.