#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 150
Default pivot table

Let me explain my situation here. I have tested few items for bacteria, yeast
and mold and entered the results in cfu (or the number of bugs) on an excel
2007 spreadsheet. If the number of bugs for any of these are above 100 on an
item, it would fail the test or is deemed contaminated. There are about 300
different items which are tested every day for these three bugs. I have three
years worth of data and I would like to analyze these using a pivot table.
Is there a way that I can make a pivot table and display the number of
failures for each category of bug. I have other information in my table like
month, year, different locations these samples were collected and so on. I
have inserted another column which filters the data and puts a '1' if cfus
are above 100 and a '0' if it is below, so that I just count the number of 1s
for failure.
Any help or suggestion would be greatly appreciated. Thanks.

Pivot table should look something like this
Bacteria failure Yeast failure Mold failure
Jan 3 4 1
Feb

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 09:22 PM
Pivot Table and Pivot Table dates are not in correct order ls Charts and Charting in Excel 3 July 14th 09 05:02 PM
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 04:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 01:48 AM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 03:36 AM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"