Forum Discussion
Total in filtered list
since a few days the totals at the bottom of my list don't show any more when I use a filter; does any one now the reason and above the cure to this malfunction? many anticipated thx
Can you post a sample file please? Or at least a screen-shot of before and after applying the filter?
Apologies can't send model data are confidential.
screenshot before filter:
screenshot after filter:
I have used this template since years across clients to follow up billing, money in and chasing; some few days ago the total line underneath, which updated when appying a filter, has gone away; I can't think of anything I would have changed in my spreadsheets (it's occuring for two differents similar spreadsheets for two different clients on two different computers).
- is your filter applied to a range that includes the total line i.e, you apply the filter and therefore filter out the total line?
- I filter mainly by client or matter or by line colour, using the little triangle on top of each column (see screenshot below). Unless mistaken this does not imply a range. Obviously the filtering now excludes the total line, which did not happened until recently.
