Is your MacBook battery draining at night? This is probably due to a piece of software on your Mac that is misbehaving and waking it while it should be sleeping. There are several ways to figure out which could be the culprit. You can use various tools to compile a list of suspects and then quit those before putting your MacBook to sleep to test them. You can also try things like reseting parts of the system and trying safe mode. You may be able to figure out the problem on your own, or you may need to take it to an expert.
When you filter rows in Numbers, any totals or other footer calculations will still be based on all of the rows, not just the ones visible. You can change that by using functions like SUMIF that match the filter. But then you need to adjust your formulas and filters every time so they are the same. However, you can use a hidden column and a single-cell separate table to make this quick, easy and useful.