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

    Set Analysis & Current Field Selection

    Shi Hui 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.



      Total Orders counts in Oceania = 1000

      Total Order Counts in Australia = 10

      Result = 100