Crosstable issue

[Anonymous]

Hi ,

I have an issue, where i have date field with sales data for the day which is getting added daily in to the excel sheet. when i perform cross table load the the new date is not being reloaded. Again I have reload this task manually. please advice

Regards,

John

[petter]

Actually you need to wrap Product in a Date() function like this

     Date(Product) AS Day

It may seem strange that Product suddenly becomes Day - but that is because the label Product is in the

pivot point of the transpose so it becomes the header for the Days after the transpose...

[Anonymous]

Thanks Petter, this is something really interesting which I was not aware of...will try this and come up with more ..

So how does this get done if have

Category          Product     16/04/2015     17/04/2015

Child                   P1,               5                10

                          P2                10               15

Men's Wear         P3,               15               20

                           P4               20               30

[petter]

Then I would rather use CROSSTABLE (....) LOAD instead and a PIVOT TABLE like this:

[buzzy996]

PFA, hopes simple cross table will helps here,