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 ?