Change column header depending on marked row

[John Beltran]

Hello,

I have two cross tables on a single page.

The first cross table is a summary that has Components on the horizontal axis, and Facilities on the vertical axis. The cell values shows colors "RED", "YELLOW", or "NA". The second cross table is a drilldown of the marked row on the summary table, with the horizontal axis Components and Type on the vertical axis. The cell values are a count function.

What I need is to have the color of what I marked show below each component in the drilldown.

Summary

 

 

 

Facility

COMP1

COMP2

COMP3

 

 

FAC1

NA

RED

RED

 

 

FAC2

YELLOW

NA

RED

 

 

FAC3

RED

RED

YELLOW

 

 

 

Drilldown (If I mark the FAC2 row)

 

 

 

Type

COMP1

COMP3

 

 

 

YELLOW

RED

 

 

TYPE1

12

 

 

 

TYPE2

11

4

 

 

 

Does anyone know if this is possible with cross tables Any tips on how to do it I appreciate the help.

 

Thanks,

John