| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Field Data count
Hello,
Does anyone knows the code in VBA to know how many diferent items a pivot table field has??? I´m looking for something like: MyPivotTable.PivotFields("MiPivotField").Count Thank you in advanced. Mónica |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Field Data count
MyPivotTable.PivotFields("MiPivotField").PivotItem s.Count
Mónica wrote: Does anyone knows the code in VBA to know how many diferent items a pivot table field has??? I´m looking for something like: MyPivotTable.PivotFields("MiPivotField").Count -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| change 'count of' to 'sum of' in pivot table field | Excel Discussion (Misc queries) | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Hybrid Mode
