3 Replies Latest reply: Jan 23, 2015 2:48 AM by Aditi B RSS

    Set Analysis - market share


      Hi, I am trying to do my first set-analysis calculation. The Help file makes this look fairly straight forward, but does not seem to work for me.

      I have 3 fields in the same table: "Sales", "Product" and "Market". I need to take the sum(Sales) of the current product selection, and divide by the sum(Sales) for the associated market. The market will comprise all products in the same table that are associated with the market.

      Thanks in advance for your help, I think once I understand the syntax of the set analysis calculation I will be on my way.