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?
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:
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.
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
