14 Replies Latest reply: Nov 19, 2010 6:05 PM by Michael_T RSS

    Set Analysis with 3 Fields

    Michael_T

      I have three fields: Units, Period, Customer

       

      I am trying to use Set Analysis to create a set of sum(Units) where Period = 3 and the Current customer is selected (this value is at least one selected).

      I need to use the whole available set not just current because the user can change the Period selection. What is the best way to do this? I have tried

      sum({1<Customer=, Period ={'3'}>} Units) and many other possibilities but I still can't get it to function properly. Thanks for your help.