Daily posts of Excel tips…and other stuff
Archive for the ‘Pivot Tables’ Category.
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 [...]
In Creating a Simple Pivot Table, I showed how to summarize the data by one field, namely summarizing sales data by the city field. In this example, I show how to summarize the data based on two fields, a row and column field. Assume you have a list of expenses, their dates, and [...]
Pivot tables can be used to summarize data in interesting ways. In this example, I start with selected data from the Invoices table of Northwind.mdb. The table contains 2,156 rows, each representing one invoice. The selected data is the Customer ID, City, and Extended Price. I want to see the sales [...]
