Is it possible Multiple Set Analysis in one Expression?

[#1]

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

[kaushiknsolanki · Accepted solution]

Hi,

    Considering you have a projectid, Year and status.

    Create a straight table with dimension as projectid,status with expression as

    sum({<Projectid = p({1<status = {"In Progress"}>}Projectid),Status = {"Complete"} >}1)

    Let me explain how it will work.

    It will give you project id where the status is in progress without considering the filter where as project id when status is complete based on selection.

    Try it and let me know.

Regards,

Kaushik Solanki

[#3]

Almost correct only there is small difference in displaying records. I am checking this.

Thanks a lot for your valueable time & great idea....