Abstract
Transcript
Hey, Dave here from Exceljet.
In the first video, I talked about how fast they are.
Let’s go take a look.
And when I hit OK we’ll get 26 properties, so that’s the new set of data.
I’m going to undo that… undo, undo, undo.
And let’s look at another way to do it.
So Ctrl + T will do that and, when I click OK, we’ll get the table.
So, converting your data to a table first is the best way to solve this problem.
And this happens most commonly because the source data just doesn’t contain an entry for that particular subtotal.
Now, this respects the prefs for number formatting.
it’s possible for you to hand that out to somebody else or use it any way you like.
Okay, so in this example, we have a large set of sales data.
Excel will automatically name your value fields, and that names just not very intuitive.
So, if you want, you could just rename it to anything you want.
So, the problem in this case is we want to show both count but also with a percentage.
In this case we’ll use percent of grand total.
And now we have both a count and a percent of total.
So in this case, the problem is we don’t want the data sheet.
We just don’t want this data sheet to be in this worksheet.
I’m going to undo that.
So here I’ll just do currency, and no decimal places.
And now, no matter how I break this down, we’ll get the currency number format retained.
The date in this case has already been grouped by quarter.
But you notice that we get these kind of strange labels at the top column labels and row labels.
They really don’t make any sense.
They take up space and make the column wider.
