I have a pivot table giving the sum and deviation of a column of data. How can I get the pivot to exclude data where the count of a batch is less than 2? Sample attached
I have a pivot table giving the sum and deviation of a column of data. How can I get the pivot to exclude data where the count of a batch is less than 2? Sample attached
Last edited by Lourens; 07-18-2011 at 08:52 AM.
Hi
I have added a new column to the source data with a formula of
=IF(COUNTIF($B:$B,B7)=2,FALSE,TRUE)
In the attached workbook, I called this column Include and added it to the Page field area, and selected TRUE
--
Regards
Roger Govier
Microsoft Excel MVP
Thanks Roger - looks like it will solve my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks