| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting range criteria in pivot table
Can I freely set a range criterion(a) for counting? e.g. for the following
data, can I set < 80 or 100 or <120 and 80 DYNAMICALLY? I can do that by adding columns to check the conditions but it then constrains my mind as I cannot see the statistics in real time. Thanks. GFR_Base 80.161 86.994 128.392 108.492 126.251 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting up a pivot table via macro? | Excel Discussion (Misc queries) | |||
| Changing a field setting in a pivot table | Excel Discussion (Misc queries) | |||
| Setting Range in Pivot Table | Charts and Charting in Excel | |||
| Setting up "Year to Date" Calculations in a Pivot Table | Excel Worksheet Functions | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Threaded Mode
