AnsweredAssumed Answered

Count records based on 2 criteria for cross tab report

Question asked by robinsugiura on Aug 28, 2014
Latest reply on Aug 28, 2014 by philmodjunk

Title

Count records based on 2 criteria for cross tab report

Post

     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?

     Thanks!

Outcomes