excel table query

[ushaanu]

Hi all,

i have data in table option and enable total row option, now I need when select any name is automatically reflect last total row my employ name is in column A ,

thanks
Anu

 

[AliGW]

There is no sample data in the table, but when you filter the table, the SUBTOTAL will reflect only visible cells. Can't see a problem here.