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