A great feature about a table is that you have an opportunity to add a total row, which can calculate totals based on your filter set here. So I'm going to create a quick table using the keyboard shortcut on a PC Ctrl T. After I have my, my table I would like to do is be able to discover our sales by those that are in Ohio. So first I'm going to select Ohio, ah. And then I'd like to quickly calculate the sales here. So it's really cool, you can just go up to total row that will automatically bring in at the bottom of the table a total row, the last field will be calculated. And we have a some calculation there.
If I had no data sets on the last numbers on the last row, then It could be that it was posting account instead. So there's that scenario there. Now, you can also go to any other row. For example, I go to net promoter score, and see what the average is by clicking the drop down. It's like an average, like that. Now, when I clear the filter, show everything, I'm going to have the ability to do the entire data set the entire table here, here's our average.
Here's our year to date sales here. Pretty cool stuff here. Keep in mind that if you wanted to keep adding more data, if I have new records, I'm going to turn off the total row. I'm going to copy and paste below, add to it. And then I'm going to come back to the table tools design tab, click on to row. One mistake people make when they're trying to find total rows.
They if they don't see it, it's because they're outside the table. So if you're not in the table, you're not going to have that extra tab that pops up when you click on the Table there's a table tools contextual tab that will allow you to grab that total row there for you. The keyboard shortcut is Ctrl Shift t as well.