Hi,
I have data like following table:
Employee | Class | Flag |
A | 111 | N |
A | 121 | Y |
A | 131 | N |
B | 211 | Y |
B | 212 | N |
C | 311 | N |
But i want single row for every employee. So I have used Concat and I have table like below:
Employee | Class | Flag |
A | 111/121/131 | N/Y/N |
B | 211/212 | Y/N |
C | 311 | N |
But I want to display class with flag 'Y' in red color, rest of with black.
Employee | Class | Flag |
A | 111/121/131 | N/Y/N |
B | 211/212 | Y/N |
C | 311 | N |
How to achieve this?
Thanx in Advance..!!