Skip to Content
0
Jul 21, 2008 at 09:26 PM

CrossTab Questions

198 Views

I have a crosstab that looks something like this:

	Jan-08	Feb-08	Mar-08	Apr-08	May-08	Jun-08
Jan-08	A	B	C	D	E	F
Feb-08		G	H	I	J	K
Mar-08			L	M	N	O
Apr-08				P	Q	R
May-08					S	T
Jun-08						U

There are two things I need to be able to do with this crosstab. First, I need to be able to paint the diagonals in different colors. For example, AGLPSU needs to be red, BHMQT needs to be blue, CINR needs to be green, DJO needs to be orange, EK needs to be brown and F needs to be yellow. There is no specific rule for these colors, just that each object within a diagonal needs to be the same color and each diagonal line needs to be a different color. In otherwords, the highlighting of each object is based on location and not value.

The second thing I need is to present a version of this crosstab as a % where AGLPSU are all 100%, B is the % if G, C and H are % of L, DIM are each the % of P, etc.

I can't figure out how to do either of these, or if it is possible to do either of these. If not, the client will be forced to export to Excel which frustrates the purpose of the report.

Fuskie

Who hopes someone has a positive answer...