2 Replies Latest reply: Jul 3, 2017 3:32 AM by Henric Cronström RSS

    Sequence of set modifiers affect the performance of Set Analysis

    Shoaib Ahmed

      Hi All,

       

      Does the sequence of set modifiers affect the performance of Set Analysis if we assume that set modifiers work internally the same way as selections? For example if I have a Set as below, Field1 has 6 distinct values, Field2 has 21, and Date has 41.

       

      =Sum( {$<Field1={'A'},Field2={'B'},Date={"<=$(…)"}>} Sales)

       

       

      Thanks

      SAK