How to access a special column in the totals row of a table?

Question

I have the following table for example:

Name	Sales	Region
John	23	West
Uwe	45	West
Mary	39	East
Doris	12	West
Peter	8	East
Total	127	5

The table is named 'myData'.

I can access the Totals row by myData[#Totals]. I can access the Sales column by myData[Sales]. But how to access the column Sales in the Totals row, so that I get the 127 in the example? The AI suggested answer myData[#Totals][Sales] does not work.

Answer 1

Try to type = into formula bar, then click the “127” cell, and press <Enter>. The result will be =myData[[#Totals],[Sales]] or =myData[[#Totals];[Sales]] depending on the current separator.