Calculate Market Share in Pivot on Sub Dimensions?

Fri, 27 Nov 2015 13:23:46 GMT

Hi,

I have a Pivot as follows

France

Prod A

Prod B

Prod A

Prod C

Prod E

Italy

Prod A

Prod E

I want to see each Prod Market share vs total Country but do not really get the generic formula to work.

e.g. Can I referer to the Country Dimension dynamically in the calculation e.g. Value/Total Country=P Data or something

Thanks

Re: Calculate Market Share in Pivot on Sub Dimensions?

Gysbert_Wassenaar — Fri, 27 Nov 2015 15:00:49 GMT

Try something like this: Sum(Value)/Sum(Total <Country> Value)