Table-->Last row - Subtotal

[lezawang]

Hi
If I insert a table then add "Last Row" which allows me to use Subtotal embedded functions. Can I move that Row at the top instead of at the end? Thank you very much.

 

[Alex Blakenburg]

No but unless you actually want it in the body of the table you can achieve the same result by using the Tables Structured referencing.

eg say 2 lines above the table, you want the sub-total for the amount column, by using subtotal(109,TableName_FieldName), you will get a total that will automatically expand and contract with the table.

20210304 Table Total at the top.xlsx
	A	B	C
1
2
3	Filter Total (Sub-Total)		30
4
5	Product	Desc	Amount
6	A01	Apple	10
7	O02	Orange	10
8	P03	Pear	10
9
Sheet1

Cell Formulas
Range	Formula
C3	C3	=SUBTOTAL(109,MyTable[Amount])