Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Column selection in pivot tables
I have a spreedsheet that contains 4 columns of similar information.
In the pivot table I would like for it to search all four columns and do a count instead of just one column. ex.1 crime 1 crime 2 crime 3 crime 4 burglary theft escape Publ Int. burglary theft burglary OVWI OVWI burglary burglary theft OVWI Pub. Int. burglary in my pivot table I have each column set up in a drop down selection in the "page area". However if I select burglary in each of the crime columns it shows nothing b/c there is no row that contains: ex.2 crime 1 crime 2 crime 3 burglary burglary burglary that is the only thing it looks for. How can I set it up to search for all the burglarys and show them on the chart. So like back to ex. 1 crime 1 crime 2 crime 3 crime 4 burglary theft escape Publ Int. burglary theft burglary OVWI OVWI burglary burglary theft OVWI Pub. Int. burglary I would select burglary and the pivot table would calculate that there were 6 burglarys and show it in the table as well. Can someone explain to me how I can do this. And please keep in mind that I am still a beginner. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Pivot Tables - Row Selection | Excel Discussion (Misc queries) |