May be Try:
Source:
LOAD
[Row Labels],
Fabs([Sum of Value]) as Value
FROM
(ooxml, embedded labels, table is Sheet1)
Where
Not Match( [Row Labels], 'Grand Total');
Concatenate
Temp:
NoConcatenate
LOAD
SUM([Sum of Value]) as Value
FROM
(ooxml, embedded labels, table is Sheet1)
Where
Not Match( [Row Labels], 'Grand Total')
;
Let vValue= Peek('Value', 0, 'Temp');
Drop Table Temp;
Totals:
Concatenate(Source)
LOAD
'Grand Total' as [Row Labels],
$(vValue) as Value
AutoGenerate(1);
