Crosstab Question

[DBAFrog]

I have 2 categories ~ VOP and FTA, but they have
sub categorized FTA into FTA, FTA-A, FTA-B & FTA-C so
when I run my crosstab I get:

FTA
FTA-A
FTA-B
FTA-C
VOP

All I need to show is: VOP and FTA as a ROWS. How do I add the FTA's into a single summed row?

thanks

------------------
Curious by Nature,
Linux by Design

 

[synapsevampire]

Create a formula to use in the cross-tab with:

left({table.field},3)

-k

 

[DBAFrog]

I did and got 3 rows of FTA returned. They didn't sum together...Thoughts?

------------------
Curious by Nature,
Linux by Design

 

[lbass]

You have to use SV's formula as your row field, not just replace the row label with the formula.

-LB

 

[DBAFrog]

Ah...TY. I had added the formula into the field properties.

------------------
Curious by Nature,
Linux by Design