Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Pivot Table - All Others

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
I'm exploring a concept that would be easy to do by writing a query, but I'd like to make this option a little more available to my users through a Pivot Table -- if this option doesn't exist it might be a welcome addition by Microsoft.

Here's a simple example:

Let's say we have 25 different products with sales totals for each. We put a field called "Product Name" in as Row Data. And we setup Data/Calculation/Summary fields to show total sales by product and a % of total sales by product. (That means two separate lines of summary info for each item selected under "Product Name.")

If a user chooses to show data for all products, you have a Pivot Table that's now 50 lines long, before you get to grand totals. (Pretty daunting!)

What if you want to pull out just a couple products and compare them to total sales....I'd like the user to be able place check marks beside a couple of the names displayed as options under "Product Name" and then have an option to combine the numbers for all others. The result would be something like:

Product A Sales in Dollars 200,000
% of Total Sales 20.0%
Product B Sales in Dollars 100,000
% of Total Sales 10.0%
All Others Sales in Dollars 700,000
% of Total Sales 70.0%
Grand Total Sales in Dollars 1,000,000
% of Total Sales 100.0%

And, alternately another user might pull out Product F and Product G and want an All Others line.

Am I missing an obvious, existing feature or does anyone have an idea on accomplishing this?
  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP