Calculate Market Share in Pivot on Sub Dimensions?

[#1]

Hi,

I have a Pivot as follows

France         

     Prod A    

     Prod B    

UK

     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

A

[Gysbert_Wassenaar]

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