Problem date(month) in crosstable

Anonymous — Wed, 14 Nov 2012 03:04:12 GMT

HI, i have problem with my date in crosstable

this is my sample data

and i want to create table with structure Code | Harga Cost Average Costing | Period | Cost

I was trying this code :

Accounting:

CrossTable(Period, cost_acc, 2)

LOAD *

FROM

[Book1 (3).xlsx]

(ooxml, embedded labels, table is [Cost Avg Acc(versi accounting)]);

and i try to view month with this formula :

accounting_version:

load * ,Month(Period) as bulan

Resident Accounting;

drop Table Accounting;

but the value 'bulan' is empty

Any suggestion, what should i do?. Thanks in advance

Akbar

Re: Problem date(month) in crosstable

Wed, 14 Nov 2012 05:19:37 GMT

Hai,

Pls Find The Attachment

and go to script and find the Answer

Regards,

Chandu