Re: Pivot Table List

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

JayMan wrote:
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.

"Debra Dalgleish" wrote:


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 Work*** 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.

JayMan wrote:

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.
"Debra Dalgleish" wrote:



Can you type a small sample of the data, and describe how you'd like it to appear in the pivot table?

JayMan wrote:


I have a Pivot table from a large Spread*** (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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

Quantcast