Some Guidance Please - Newbie questions (Cannot sort my data)

[T12390814]

Hi - and thanks in advance......

My goal is to have an updating Sales Charts based on our sales reports.

Having used Looker my thought was to use Col Series (Stack) with an X axis of Date and a Y Axis of Pounds (ITEM SUBTOTAL), with the Stacks breaking down by Sales country.

My problem - I simply cannot get my date fields to work and unlike Looker cannot easily get the 3rd variable  (i.e. ShipCountry) to stack.

My Core data looks like the table below (with more rows).
The Week Output is annoyingly a Text field.
Can you suggest how I can transform the data within Appsheet to make this work? I have the option of transforming the GSheet data before loading it to Appsheet but cannot alter the actual Data dump. I have tried various methods but they feel clunky and I am sure I am missing a basic element to get this working better.

Ship Country	Week	Year	Item Subtotal
SE	Week 12	2024	£ 149.73
SE	Week 14	2024	£ 149.73
SE	Week 18	2024	£ 351.30
PL	Week 8	2024	£ 68.29
PL	Week 13	2024	£ 139.85
NL	Week 4	2024	£ -
NL	Week 6	2024	£ 12.58
NL	Week 7	2024	£ 12.58
NL	Week 8	2024	£ 12.55
NL	Week 10	2024	£ 12.57
NL	Week 13	2024	£ 25.46
NL	Week 14	2024	£ 12.75
IT	Week 2	2024	£ 33.16
IT	Week 4	2024	£ 66.92
IT	Week 5	2024	£ 67.16
IT	Week 6	2024	£ 49.81
IT	Week 7	2024	£ 231.11
IT	Week 8	2024	£ 82.44
IT	Week 9	2024	£ 183.80
IT	Week 10	2024	£ 98.94
IT	Week 11	2024	£ 66.29
IT	Week 12	2024	£ 97.28
IT	Week 13	2024	£ 49.99
IT	Week 14	2024	£ 83.34
IT	Week 16	2024	£ 134.18
IT	Week 17	2024	£ 182.25
IT	Week 18	2024	£ 83.88
GB	Week 1	2024	£ 7,551.56
GB	Week 2	2024	£ 7,665.97
GB	Week 3	2024	£ 8,020.28
GB	Week 4	2024	£ 8,355.20
GB	Week 5	2024	£ 8,157.30
GB	Week 6	2024	£ 8,261.95

Here is an image of my Table Data Configuration and Chart