Cross Table Load in Differences between Wizard Result and Actual

[#1]

Hi,

I'm having an issue where when loading in a set of data via Cross Table, the Wizard Result is showing correctly but when i load the data it comes out differently.

For Example; the Wizard shows

and displays the values correctly as per below in the Results

However, when i load the report, it displays the below instead

Here's the load in script it creates;

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CrossTable([Financial Week #], Data, 2)
LOAD Porfolio,
     [Actual / Forecast],
     1,
     2,
     3,
     4,
     5,
     6,
     7,
     8,
     9,
     10,
     11,
     12,
     13,
     14,
     15,
     16,
     17,
     18,
     19,
     20,
     21,
     22,
     23,
     24,
     25,
     26,
     27,
     28,
     29,
     30,
     31,
     32,
     33,
     34,
     35,
     36,
     37,
     38,
     39,
     40,
     41,
     42,
     43,
     44,
     45,
     46,
     47,
     48,
     49,
     50,
     51,
     52
FROM

(biff, embedded labels, table is Margin$);

I'm not changing anything between clicking 'Finish' in the Wizard and clicking 'Reload' but the data just wont load how i'm expecting it to.

Is this a Bug or am i doing something wrong?

Thanks in advance.

[martinpohl · Accepted solution]

I think it's a bug,

it happens to me too.

I think it is because of the numbers in your caption.

Set the number in brackets

[1],

[2],

and you will get the right result.

Regards

[#3]

Excellent.

Thanks very much!

Regards,

Nick