| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Boolean Values in Pivot Table
I have a pivot table feed off a table 2 column talbe with booleans in teh
second column. I want te count the TRUE occurences. However the Count property of the Field is counting both TRUE and FALSE answers. How do I only count the TRUES? OR do I have to use a COUNTIF in a manually created table? Thanks EM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Boolean Values in Pivot Table
Merely place the 2nd column in your row fields and filter by only True.
"ExcelMonkey" wrote: I have a pivot table feed off a table 2 column talbe with booleans in teh second column. I want te count the TRUE occurences. However the Count property of the Field is counting both TRUE and FALSE answers. How do I only count the TRUES? OR do I have to use a COUNTIF in a manually created table? Thanks EM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format for boolean values | Excel Discussion (Misc queries) | |||
| Track Count of Boolean Field in Pivot Table | Excel Discussion (Misc queries) | |||
| Evaluate boolean values as 1 or 0 | Excel Worksheet Functions | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
Linear Mode
