on 06-09-2011 3:59 PM
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 ?
try to create a virtual characteristic for Candidate
and assign candidate values to the virtual characteristic only if candidate status is "HIred".
And make use of this virtual characteristic in the query.
--- Thanks...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From My view this is not possible in Query.
You can do this in Backend or
You can create 2 Query
1.Query whith candidate name who is hired.
2.Query without candidate name whose status is not hired.
3.Merge these these report using Excel Macro.
Thanks and Regads,
MuraliManohar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.