Set Analysis Exclude Ex.

[#1]

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

[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