1 Reply Latest reply: Sep 19, 2011 2:45 AM by Jason Michaelides RSS

    Set Analysis Exclude Ex.

      Dear Friends,

       

              if any one knows the Set Analysis Exclude Ex. pls forward to me.my req. is monthly not invoiced parties [from sales].

       

      with rgds

       

      chandru.p

        • Set Analysis Exclude Ex.
          Jason Michaelides

          Hi,

           

          This is almost impossible to answer without knowing more about your data model. For example, how do we know if a sale has been invoiced? Having a total guess though:

           

          Sum({<Invoiced={No}>} Sales) in a chart with Month as a dimension.

           

          Hopefully this will get you started. The F1 help on set analysis is very good by the way.

           

          Jason