4 Replies Latest reply: Jul 7, 2011 10:50 PM by Shihui Zhang RSS

    Set Analysis & Current Field Selection

    Shihui Zhang

      Hi all,

       

      I need some help in formulating a set analysis for my table. Currently I have a region list box consisting of ( America, Asia, Oceania, etc etc) and a country list box (Australia, South africa etc)

       

      I would like my end result to be like this ---> Sum of Order for the current selection in region list box divided by Sum of orders for the current selection in country list box.

       

      Example:

      Total Orders counts in Oceania = 1000

      Total Order Counts in Australia = 10

      Result = 100