Have you ever recorded a macro while hiding a Subtotal in a PivotTable? You basically get something like this:
ActiveSheet.PivotTables(“PivotTable1″).PivotFields(“Budget Status”).Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False)
That’s right. There are twelve Falses here. What’s crazier than that, if you try to leave out any of Falses, the code bugs out.
So why all the annoying Falses?
Today, I want to show you a trick that’s been around for a while. I think I first learned this trick from J-walk’s site pre-Walkenbach pony tail.
With this trick you can transpose an entire table using a ‘Multiple Consolidation Range’ PivotTable.
Every now and then, I have to deal with a situation where a normalized dataset makes it difficult to build an appropriate pivot table.
Here’s an example:
In honor of the upcoming 4th of July weekend, I’ve declared this week to be Pivot Table week. What do Pivot Tables have to do with Independence day? I’ll let you know when I find out.
In the meantime, are you ‘that guy’ who keeps clogging everyone’s email with 20 megabyte files. I want to share a simple trick to cut the size of your Pivot Table workbooks in half. » More: Cut the Size of Your Pivot Table Workbooks in Half
If you’ve been following the blog, you’ll know that it’s Pivot Table week. That’s right. All in honor of the upcoming Independence Day holiday.
Here’s another dose of PivotTable awesomeness. (That’s right Kusleika, I said ‘dose’. You don’t own that word.)
Today I’ll show a trick I often use to explode a dataset into separate workbooks – using a pivot table.
In honor of the upcoming 4th of July weekend, I’ve declared this week to be Pivot Table week.
Afterall, what’s more American than slaving away on a pivot table during a holiday.
In today’s post, I’d like to share a trick that allows you to create a frequency distribution with a pivot table.
» More: Creating a Frequency Distribution with a Pivot Table
It’s almost the 4th of July here in the US – probably everywhere else in the world too. But in the US, the 4th of July is Independence Day.
So in honor of the upcoming 4th of July weekend, I’ve declared this week to be Pivot Table week. I’m pretty sure our founding fathers used pivot tables.
Today, I’ll show you a trick to add visualizations into your pivot table. » More: Adding Visualizations to your Pivot Tables
