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"
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