Skip to Content
0
Former Member
Jul 29, 2016 at 09:54 AM

Conditional Formatting in Cross Tabs

26 Views

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 2

For 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?