Forum Discussion
Filter total
I have a table with data and days of the week with numbers in it. I want to filter the data and have the total summed for a single day instead of me having to highlight it and enter the data. (So if...
I would format the data as a table: Home->Styles->Format as Table
Then click within the table, go to the "Table Design" tab, and check the "Total row" option
After that, you can set Totals for each column, which will be recalculated every time you apply filters to any column