Hi all,
I have two queries:
1. select Column A, Column B, Column C
2. select Column A, Column B, Column C, Column D
I have merged Column A , Column B, Column C of the two queries and build a cross tables as below
Merged Column C Column D Merged Column A(Measure) Merged Column B(Measure)
When I try to apply conditional formatting into Column C, it doesn' work if there is no result return for query 2
Column C Column D ABC ABC 1 12/21/2014 DEF DEF 2For example, the conditional formatting didn't apply to value 2 in the second row above as result of Column D is null.
It looks like when Column D is null, it will also treat Column C as null
Any idea to solve this?