Count records based on 2 criteria for cross tab report
I am trying to make a cross tab report that shows counts for records that meet 2 criteria: field1 (30 values, Y axis of table) and field2 (5 values, X axis of table).
I think what I need to do is make two fields for each cell of the cross tab report table:
Calculation CalcField1 from TABLE = If ( FIELD1 = "F1VALUE1" and FIELD2 = "F2VALUE1" ; RESULT )
Summary SummField1 = total of CalcField1
and then put SummField1 in the table at the location of field 1 value1 and field 2 value 1.
Where I am stuck is what is the RESULT?
I found a similar table someone else made in the same database, and their RESULT is a calculation field CountRecordsAll from TABLE = Sum (Constant)
I tried to use that same field as my result, but no values are being calculated in those fields.
Can someone help me figure out what I am doing wrong, or give me other ideas how to accomplish this?