Pivot Table List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Pivot table from a large Spreadsheet (3500 Rows) which reflect the
outages of 1500 applications. Most have not had any outages. When i create my
Pivot table I need to be able to sort the results be different groups, Sales,
Marketing for example. The Sales Group might have 50 applications and
Marketing 75 app but they are diff apps with some over lap.

right now i am manually reviewing the list selection drop down on the field
area and selecting the applications.

My question is this: Is there a way to filter the selection based on some
sort of list either on another tab or inserted somewhere
 
Can you type a small sample of the data, and describe how you'd like it
to appear in the pivot table?
 
Just the application list would be fine.

The source data looks something like
Problem ID App Duration
123-456 ABC 125
123-690 DEF 158
123-970 DEG 562

From the Sort List if ABC and DEG belong to sales i would create the pivot
and manually select just those applications.

Then i would re-run the Pivot and just select DEF and DEG since those are
important to Marketing.

As far as output I think the rest is easy just the duration and counts which
I can do woith the Field settings

Thanks for your help. I thought this questions was the type you would like.
 
I'm not sure if it's exactly what you're trying to do, but I've added a
sample file here:

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'PT0013 - Filter From Worksheet Selection'

With one column added to the source data, you can calculate if each
output was applicable to the selected department, and refresh the pivot
table to show only that data.
 
This looks AWESUME, one question how do I set up the list of applications and
departments?
BTW I opened this in excel 2003 and 2007 both look great. Any chance I can
get a short click by click on how to use this against my data?

Again thank you, you are one of the best posters (is that the word?) on this
form.
 
You're welcome! Thanks for letting me know that it worked in both
versions of Excel.

The file uses named ranges, as described here:

http://www.contextures.com/xlNames01.html

You mentioned a Sort List in your file, which may not look exactly like
the AppUse named range in the sample file, so you could adjust it.

The formulas in column D check the AppUse table, to see if the
application in that row is used by the selected Dept.

Event code refreshed the pivot table after you select a department in
the cell above the pivot table.
 
Back
Top