7 Replies Latest reply: Jan 5, 2010 5:52 PM by Joao Morais RSS

    Set Analysis: Selection based on values from disconnected field.

      I have a disconnected table which I'm trying to use to define a set, for example

       

      Sum({<Value=DisconnectedValue>} Amount)


      As specified in help:

       

      There are several ways to define the selection: A simple case is a selection based on the selected values of another field, e.g. <OrderDate = DeliveryDate>. This modifier will take the selected values from DeliveryDate and apply those as a selection on OrderDate. If there are many distinct values - more than a couple of hundred - then this operation is CPU intense and should be avoided.


       

      But I can't get it to work. Anyone have any pointers? Thanks.