The formula for the last number of the column (table)

[sovietchild]

Hello, how are you? I use this code =LOOKUP(9.99999999999999E+307,A1:A50) for the last number of the column but this code does not work for a pivot table because the table always growing.

What is a similar code that can work for a table column?

[Glenn Kennedy]

Try:

=LOOKUP(9.9E+307,Table1[Row Labels])

[sovietchild]

Try:

=LOOKUP(9.9E+307,Table1[Row Labels])

Thanks, it worked but it does not want to work for a pivot table. Do you know why? Here is a new upload.

[xlnitwit]

Why do you need to do that to a pivot table?

[sovietchild]

Why do you need to do that to a pivot table?

I'm a nub. I just need to know the last number so I could build a trending row (under totals) for this dashboard. So basically +$6000 (the last # of the table)

1. dashboard tv.png

My job as a data miner, is to mesmerize my client.

[sovietchild]

Oh wait, I think I get it. It auto. gave me the code by just clicking on the pivottable

=GETPIVOTDATA("[Measures].[Sum of TOTALSALES]",$AU$1,"[Date].[DATE]","[Date].[DATE].&[2018-02-16T00:00:00]")

Sorry for any disturbances