Adding vertical sum of rows(Sum in last availble column) for Transposed data Slight modification due to rows data increased limits

[Sameer]

Sir,
I have ItemNames currently till today 419 Items*3( ItemNames,Data1 and Data2) = 1257 so might be this is not a issue for through an error.

I just re tried to run the test data not throw any error retrieve the rows in post https://forums.sqlteam.com/t/adding-vertical-sum-of-rows-sum-in-last-availble-column-for-transposed-data/20382

But when i try to run the new Script with Totals find error required your suggestion?

@JeffModen

I get that. But you posted some results in a spreadsheet and I asked you a question about the spreadsheet. Is that the ultimate target of the data?

The excel results are based on your previous sent script which worked very fine and excel spreadsheet screenshot attached desire results,since January now might be the naming convention of ItemName through error..