Playing with Crosstable

[Jewelson Cagakit]

1. How can i arrange my crosstable from January to December---they are arranged alphabetically by default (A to Z).
2. I don't see any tutorial videos on basic application of conditional formatting on Crosstable cells. Please teach us how.

[Kirsten Smith (she/her)]

For the first issue I would guess that your month column is a String instead of a Date. (Check under Data/Column Properties). You can use Column Properties to create a Custom Sort Order under the 'Sort Order' tab.

For the second issue please provide some more details about what you are trying to accomplish - conditional on what? Also what are you trying to format - column, color, calculation, etc.

[Jewelson Cagakit]

Hey Kirsten,

1. Your suggestion works! How can I do the same for custom sorting of rows?
2. Here is my goal on my example table

For Maverick Category, Auto Column condition if the Actual number is greater than 2.5% the cell background should be red, else <2.5% the cell background must be green. and so on and so forth(for LVM, HVM, and Discrete), how can I assign color conditions (Red and Green) for Actual vs goal ? Please see attached captured image. Im stuck for days on this .. :-(

[Jewelson Cagakit]

Hey Kirsten,

Pls disregard case number 1, I did it as well !

Please help me with the case #2, please ..

[Kirsten Smith (she/her)]

To set the colors go to Properties/Colors.

1. Click on 'Add' and select the column that you want to color. Set the Color mode to Segments
2. Click on 'Add Point'
3. Set the point that you want to color above and below, and set the colors accordingly

Since you are using percentages you may have to enter 0.025 as opposed to 2.5, depending on how your percentage is being calculated.

[Jewelson Cagakit]

Hi Kirsten,

I tried, but starting with the "AUTO" column, when i selected the Segments color mode, this happened.

 

Not sure if Im doing it right? .. In this case, LVM, HVM, DISCRETE, IC and MOSFET columns have their own respective goals : 3.3%, 11.2%, 3, 2, and 2.7% ..

[Kirsten Smith (she/her)]

That looks right, just put the desired value in the added point, and adjust the colors accordingly.

For the other columns just repeat the process.

[Jewelson Cagakit]

When i apply a point on "AUTO" column, the result applies for the rest of the columns.

I think I am doing it wrong?

Tried adding a point for "LVM" still, it applies to the rest of the column and overwritten what I did on the "AUTO" column..

[Kirsten Smith (she/her)]

Make sure you are adding each column separately to set the desired colors. Attached is a sample file so you can see how it works.