is there a Cross Tab alternative???? 1

[mstelmac]

record_id priority
num00001 1
num00002 1
num00003 2
num00004 2

Hi guys, new CR developer here. I have 4 records that I created a group for. Now I want to subtotal the group (i.e. there are 2 priority 1 and 2 priority 2 records). I need to have the totals on the report footer page and the crosstabs functionality does not allow the format that I want. I figured that I could draw the figure that I wanted and insert two formula fields.
count ({table_name.sum_priority_1}) = "1"
count ({table_name.sum_priority_2}) = "2"
I was then going to insert these formula fields into my homemade chart, but the formula doesn't work!!!!!!
Any suggestions? Your help would be greatly appreciated.

 

[synapsevampire]

I wonder what a homemade chart is...

Anyway, try using a Running Total Field, and in the Evaluate->Use a Formula place:

{table_name.sum_priority_1} = "1"

for the ones, and

({table_name.sum_priority_1}) = "2"

for the twos.

-k

 

[mstelmac]

synapsevampire,
Thanks very much for your response. It worked perfectly and was exactly what I needed.
-matt