 So now that I've got my filters applied one of the things I can do is I can apply this total row if I check on it What's actually going to happen is it's going to go through and it's going to add in all my numbers now Let me do a little quick format to that and we can see that I have suddenly $24,000 collectively across January 2016 still in the future But one of the things that's beautiful about this is now if I apply any of my filters either through the filter button or through The slicer say for example Saturday, I can see a total of my filter notice that 24,000 is missing So suddenly I can say what's my Saturday coffee total not really a lot But what about my special drink and that great gifts food so I can see food and Coffee those are actually sort of my hot sellers if you will so this allows me to work off of just Being able to run a total now. What if I want to run a total off again all these different filters notice That's what I'm doing here as I'm picking these filters What if I wanted to see the subtotal for say every day now? That would be a little bit more annoying if we think about it because I'd have to go through and I want to see the Subtotal of this I want to see the subtotal of this want to see the subtotal of this you get the point One of the things I can do is first I would need to convert My table into a range just a normal range We're basically removing the concept of a total or a table from our table if that makes sense One of the things you're gonna get is this dialogue box is gonna say are you sure you want to convert back to a normal Range obviously. Yes, that's why we're clicking buttons But you're gonna see we lose a lot of that same information our total row is Still there which is nice But the slicers are missing a lot of other parts are missing from this which is okay Because what we're gonna do is we're gonna come over to our data tab And we're going to select subtotal now when we select subtotal we get a dialogue box basically asking us when things change at particular things I know when things change on a particular say day or Week segment amount Transactional day when we change every day what I want you to do is use the sum function I want you to add everything up on Some number now if we left it at if we change it to say week We'd get all these week numbers getting added up But if we leave it at amount these subtotals are gonna get added up So I want the subtotal for you know January 1st for example Well, I'm gonna get those numbers and add them together and as soon as I hit okay That's exactly what we see Suddenly when transaction day when my a column changes from 1 1 2016 to 1 2 2016 we create a subtotal row and what we do well We grab all the data inside of the amount section the amount column and add it together temporarily one of the things you're gonna notice is we've got suddenly these three panels over here on the Left and if I click on say one it condenses everything down So I see the grand total if I expand it out to three that Explodes everything out. So I literally literally see everything that I saw before and on top of that the subtotals But if I click on number two number two is actually gonna give me just my subtotals So I can see all of a sudden my days without looking at all the mess Pretty nice