Add column to Crosstable

[kevbrown]

I have a crosstable but it does contact a date column. I'd like to add a date column, can i do that?

My script looks like -

CrossTable(Area, Data)

LOAD F1 AS Measures,

     [Lieder 1],

     [Lieder 2],

     [Line 3],

     [Line 4],

     [Line 5],

     [Line 6],

     [Line 7],

     [Line 8],

     [Line 9],

     [LR Traywash],

     [Line 11],

     Preparation,

     [L/R Packing],

     [H/R Bacon Room],

     [L/R Bacon Room],

     [H/R Salad Wash],

     [L/R Salad Wash],

     [Bread Area],

     [Bay 6 & Sanitiser],

     Despatch,

     Hygiene

FROM

Thanks

[MK_QSL]

CrossTable(Area, Data,2)

LOAD F1 AS Measures,

     Today() as Date,

     [Lieder 1],

     [Lieder 2],

     [Line 3],

     [Line 4],

     [Line 5],

     [Line 6],

     [Line 7],

     [Line 8],

     [Line 9],

     [LR Traywash],

     [Line 11],

     Preparation,

     [L/R Packing],

     [H/R Bacon Room],

     [L/R Bacon Room],

     [H/R Salad Wash],

     [L/R Salad Wash],

     [Bread Area],

     [Bay 6 & Sanitiser],

     Despatch,

     Hygiene

FROM

[sunny_talwar]

What date are you looking to add?

[Kushal_Chawda]

Which date you want to add?