Skip to Content
0
Former Member
Jun 09, 2011 at 02:59 PM

Display a particular column only when certain criteria is satisfied

30 Views

Hi Experts,

I have a requirement from a user with which i am struggling. The person wants to see an entire report but see a particular column only when certain criteria is satisfied. I am not talking about filtering the entire Query but just a certain column.

Ex.

Data in Cube

Req | Candidate | Candidate Status | Grade

1 | C01 | Draft | A

1 | C02 | Withdrawn | B

2 | C03 | Hired | B

3 | C04 | In Process | A

3 | C05 | Hired | C

Result in Query

Req | Candidate | Grade

1 | <Blank> | A

1 | <blank> | B

2 | C03 | B

3 | <blank> | A

3 | C05 | C

Basically, user wants to see candidate information only when Status is Hired. Rest of the time, it should be blank.

Is this possible ?