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



        • Set Analysis Exclude Ex.
          Jason Michaelides



          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.