Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a Pivot Table below and I would like to add a new row to the existing table and the value to be displayed will be 100 for FY24 (Apr-2023 to Mar-2024) and 200 for FY25 (From Apr-2024 Onwards).
Below are the load script.
-------------------------------------------------------------------------------
Table_1:
LOAD Period AS SM4_DATE_1,
[Water consumption (CbM)] AS SM4_VALUE_1,
'Office' AS SM4_SOURCE_1
FROM
TABLE_1
(OOXML, EMBEDDED LABELS, TABLE IS Offices);
Table_2:
LOAD DATE(FLOOR(Period), 'MM/YYYY') AS SM4_DATE_2,
[Water consumption (CbM)] AS SM4_VALUE_2,
'Central Office' AS SM4_SOURCE_2
FROM
TABLE_2
(OOXML, EMBEDDED LABELS, TABLE IS Summary);
Just create another Excel with the needed data - maybe per copy & paste from the others and then adjusting the values. Alternatively you may add these data within an inline-load but it won't be simpler.
Beside this both tables have the same data and therefore they should be loaded per concatenate into a single table with the identically field-names.