2 Replies Latest reply: Oct 11, 2011 6:44 AM by Gangadharan M RSS

    Is it possible Multiple Set Analysis in one Expression?

      Hi All,

       

      I have to apply conditions on 2 fields like Status(Complete or In Progress) and Year (2000 - till date, with some null values).

       

      I need to show/display the records in Straight Table / Pivot Table which meets the condition given below

       

      1. Status = In Progress ( here no year filter )

      2. Status = Complete ( based on the year selection done by the end user )

       

      Any function is ok like nested if or set analysis.

       

      The other selection fields like Dept, Product, etc.. should make the impact on this table against selection.

       

       

      All kind of suggestions are welcome....Thanks

       

      Thanks

      Gangadharan M