1 Reply Latest reply: Nov 27, 2015 10:00 AM by Gysbert Wassenaar RSS

    Calculate Market Share in Pivot on Sub Dimensions?

      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