cancel
Showing results for 
Search instead for 
Did you mean: 

counting date transactions for last six months

Former Member
0 Kudos

Post Author: crystalrook

CA Forum: Formula

Any help is greatly appreciated. I am running Crystal XI.

I have an order field (PurchaseOders.PODatePlaced) for each item. There can be multiple orders in the same month for each item of course. I would like to COUNT each PurchaseOders.PODatePlaced based on the month it was purchased for the last six months from a date parameter.

My table looks like this"

Item PODatePlaced

1234 11/12/2007

1234 11/20/2007

1234 10/15/2007

1234 9/30/2006

1234 12/5/2007

1234 12/6/2007

I am trying to get the results to read as follows (only for the last 6 months):

Items December November October

1234 2 2 1

Thanks for your help

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Post Author: crystalrook

CA Forum: Formula

I am adding a cross tab to an existing report so many of the fields are already in the report. I would like to only add the month fields and a count of the transactions. Can this be done? In the group options how can I tell it to only use the last six months reguardless of activity for the month. Current results are giving every date as a column. Can I only get the months to be columns?

Any suggestions?

Former Member
0 Kudos

Post Author: crystalrook

CA Forum: Formula

thanks. i am creating one now and will let you know.

Former Member
0 Kudos

Post Author: mmishkin

CA Forum: Formula

Use a cross tab,

Columns will be on of date (you can select group options and just pick out the last six months, discarding all others)

Your row will be Item Number

Your summarized field can be a count of the item number