Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Pivot Tables (RSS)

Browse by Tags

  • Toggle PivotFields from Count to Sum

    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 [...] Read More...
    Filed under: ,

  • Most Frequent Occurence

    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 [...] Read More...
    Filed under:

  • OLAP Catastrophic Failure

    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. [...] Read More...
    Filed under:

  • Multi-Column PivotTables

    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 [...] Read More...
    Filed under:

  • Quick PivotTables

    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 [...] Read More...
    Filed under: , ,

  • Twittering Away the Day

    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 [...] Read More...
    Filed under:

  • PivotTable Markup Language

    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 [...] Read More...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.