Daily posts of Excel tips…and other stuff
Archive for the ‘Pivot Tables’ Category.
I’ve never needed to use an OLAP cube before recently. I’ll admit that I didn’t see what all the fuss was about. But I came upon a problem for which an OLAP worked perfectly. Theoretically.
In practice (Excel 2003), I experienced error after error. I rebuilt the cube from scratch several times. [...]
J-Walk posted a link to the Top 101 Cities with the Largest Temperature etc…. The title is too long, so you’ll have to follow the link if you want the details. I wanted to see how this broke down by state. Here’s what I did.
I brought the data into Excel using a [...]
Sometime in the mid-1990s, a man named Lyle Lanley walked into Microsoft with an idea. Probably the greatest…. Oh, it’s more of an Apple idea. “Just tell us the idea and we’ll implement it”, said Bill Gates.
I’m on a quest to rid my life of wizards. The wizards that Microsoft seems [...]
The twitter experiment is now over. I used Tweetake to get my tweets into a CSV, which I then opened in Excel.
I tried to post every 1/2 hour. At the time of the post, I’d write what I did since the last post. Since I usually did more than one thing, I [...]
How do you communicate a pivot table to someone? I have a huge table of payroll transactions and I created a pivot table for my worker’s compensation premium audit. Someone else who has Quickbooks could use this pivot table for their own purposes, but I don’t know how to tell them how to [...]
This is a simple example of how to use a calculated field in a pivot table. I use the Orders table from Northwind.mdb to summarize the orders. I add a calculated field to show me the Extended Price for each product on the order. I’ll be going start to finish assuming you [...]
There were a lot of comments that people couldn’t get parameters into their pivot tables. I didn’t save the workbook with which I made that post, but I was able to recreate it. You can download it:
Download PivotTableParameters.zip
I didn’t have any trouble recreating it, other than changing the Sheet2 reference in the code [...]
Pivot tables that are based on external data are somewhat limited compared to normal external data queries. One limitation is that you can’t (read: it’s difficult) to create parameters. At least there’s no way to do it in the user interface that I’ve seen. This post will show you how to modify [...]
