update sum after i filtered the list
I know how to use sum function, however, does any one know how to update my total after I've filtered my list which changes my range.. I think it has to do with subtotal and the DSUM function on excel, I don't know how to do it on numbers.