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

julioarriaga — Sat, 16 Nov 2024 01:02:34 GMT

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.

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

chrismarlow — Fri, 27 Nov 2020 10:55:10 GMT

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.

topic Different measures depending if the pivot table is collapsed (market share) in App Development

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

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