Daily posts of Excel tips…and other stuff
Archive for the ‘Pivot Tables’ Category.
Carrie laments:
Is there a way to change the default in a pivot table so sums the values when created rather than count? It is very time consuming if you have several data points.
I hear ya, sister. Excel does a pretty good job guessing, but sometimes it gets stuck on Count like that’s all [...]
Tammy has this data:
and she wants to know who used the vehicle the most by month. I couldn’t think of an easy way to do this with worksheet functions, so I resorted to a pivot table.
With Date on the left, Driver across the top, and Count of Driver in the data area, I grouped [...]
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 [...]
