| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I summarize a selection?
I'd like to use a pivot table report to summarize the contents of several
worksheets. Is there any way to include the results of a radio button or check box selection? In other words, can I have the table include only the selections that are marked as true. Thanks. |
|
#2
|
|||
|
|||
|
You could use a column of linked cells (for the checkbox) and include that in
your data field for the pivottable. Nimbus55 wrote: I'd like to use a pivot table report to summarize the contents of several worksheets. Is there any way to include the results of a radio button or check box selection? In other words, can I have the table include only the selections that are marked as true. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table selection | Excel Worksheet Functions | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
| Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
| SELECTION() | Excel Discussion (Misc queries) | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
