Cross tab help 1

[chvchk]

I've searched the forums and have been unable to solve my simple problem.

Crystal 8.0
Pervasive Db

I have a crosstab that is giving me everything I need except I'm having trouble formatting it.
Here is what it looks like now:

2006
9 10 11 12
Customer 1 $sum 1 $sum 1 $sum 1 $sum 1
$sum 2 $sum 2 $sum 2 $sum 2

Customer 2 $sum 1 $sum 1 $sum 1 $sum 1
$sum 2 $sum 2 $sum 2 $sum 2
total sum1 total sum1 total sum1 total sum1
total sum2 total sum2 total sum2 total sum2

What I'd like to see is this:

2006
9 10 11 12
Customer 1 con $sum 1 $sum 1 $sum 1 $sum 1
tk $sum 2 $sum 2 $sum 2 $sum 2

Customer 2 con $sum 1 $sum 1 $sum 1 $sum 1
tk $sum 2 $sum 2 $sum 2 $sum 2
total sum1 total sum1 total sum1 total sum1
total sum2 total sum2 total sum2 total sum2

As you can see, I just need to add a column that will have a row heading for each customer sum type. In this case, I have two types of sales. Consigned and Turnkey. One customer can have both types of sales and the only indication of a part being consigned or turnkey is the part number format. If it starts with a alpha character it's consigned, otherwise it's turnkey.

Can anyone help me with adding a row label for each customer that indicates which summary is consigned and which is turnkey?

TIA

 

[lbass]

I think you should create a formula like:

if isnumeric({table.partno}[1]) then "Turnkey" else "Consigned"

Add this formula as your second row field in the crosstab, and use the amt field for your summary instead of conditional formulas (if that is what you were doing).

-LB

 

[chvchk]

Oh wow. I was making this WAY more complicated then I needed to.
Thanks so much. It works perfectly!!!