I have a list of dated transactions with quantities.

What I am trying to do is create 12 columns one for each month of the year starting with the current month and rolling forward a further 11 months.

I think I need to identify current month, current month +1, current month +2 etc but how can I do this with a date format of 31/10/2013?

At the same time as identifying the month in each column I also need to evaluate to different scenarios.

Scenario 1: if {SorDetail.MWarehouse} in ["C1", "C2", "C3", "C5", "C7", "CA"] then {SorDetail.MBackOrderQty} else 0

Scenario 2: if {SorDetail.MWarehouse} = 'FG' then {SorDetail.MBackOrderQty} else 0

Currently I am evaluating the scenarios individually with a month in them:

if {SorDetail.MWarehouse} = 'FG' and {@Date to Month # SO} = 'Oct'
then {SorDetail.MBackOrderQty} else 0

Any help much appreciated.
Thanks

Thanks DBlank,you are correct I now have issues with the dates on the column headers.

I am trying to combine two different date fields that are formatted YYYYMMDD hh:mm:ss.

Ideally I would like these dates formatted to MMYY and then listed in one column ie combine columns to read 1013, 1113, 1213, 0114, 0214 etc.

I think its a case that I have been messing around with this all day and I am just not getting it.

Any suggestions anyone??

Thanks again, this is fun isn't it....

The three date fields I need to use are all in date format anyway so that makes it a bit easier.

However this also makes it more difficult because I need to group them.

Tried this:
{WipMaster.JobDeliveryDate}={SorDetail.MLineShipDate}={SorDetail.MLineReceiptDat}

But it doesn't like the third argument.

If I enter them individually in the cross tab as column headers it creates three separate columns one for each field.

Ideally what I would like to have is one October 13 which looks at all three date fields.

Perhaps I am being too complicated and trying to do too much with one formula. I don't think so though.

Thanks again.