Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.