pivot table primer course
 

I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

pivot table primer course
 

I'm not sure how a pivottable would apply. Those are for creating summary
reports based on categories--totals, averages, kind of thing.

But maybe applying data|filter|autofilter
and only showing the rows that you want would work.

You could filter by date or by project or by department or by any column that
you want.

roger_home wrote:

I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks

--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson

pivot table primer course
 

If you want to read more about pivottables...

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

Dave Peterson wrote:

I'm not sure how a pivottable would apply. Those are for creating summary
reports based on categories--totals, averages, kind of thing.

But maybe applying data|filter|autofilter
and only showing the rows that you want would work.

You could filter by date or by project or by department or by any column that
you want.

roger_home wrote:

I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks

--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson

--

Dave Peterson

pivot table primer course
 

Dave,

You are probably right...data/filter/autofilter would probably work
better than a pivot table. Question: after selecting whole database,
how do you turn certain columns off?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

pivot table primer course
 

I'm not sure what you mean by turn columns off.

If you want to get rid of the dropdown arrows, you'd need some code to hide
those. But this isn't really necessary. You can just ignore those dropdowns
(or use them when you need them).

If you mean how you can see the data again, you can use the each filtered
dropdown arrow and choose All. You can also use data|Filter|show all to see all
the data without going to each arrow.

If you mean not see the columns, you can always select the columns you don't
want to see and Edit|Format|column|Hide--but this isn't using autofilter.

roger_home wrote:

Dave,

You are probably right...data/filter/autofilter would probably work
better than a pivot table. Question: after selecting whole database,
how do you turn certain columns off?

--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson

pivot table primer course
 

http://www.datapigtechnologies.com has many short videos which I think are
great - Bob Umlas, Excel MVP

"roger_home" wrote:


I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

pivot table primer course
 

There are a number of good sources. Start he


http://www.contextures.com/xlPivot02.html
--
Gary's Student


"roger_home" wrote:


I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269