Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enumerating PivotItems collection fails to display duplicate values
I have a PivotTable laid out with 5 RowFields. The 5th RowField
contains some duplicate strings amongst its PivotItems collection. When I walk all of the PivotItems in a loop statement, the duplicate strings don't enumerate. So if I had for example, 50 PivotItems and 5 of them were duplicate values of another PivotItem, my loop statement would only show 45 PivotItems, just the unique strings. Is there a way to enumerate all 50 PivotItems? There is unique data within the 1-4 RowFields for each item in the 5th RowField that I have to enumerate. Maybe my current implementation is the problem? For each PivotItem I enumerate, I get it's associated PivotItem.DataRange.Row value and pull data from columns "A", "B", "C", "D", where those would equate to RowFields 1-4 in my case. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display only duplicate values and delete UNIQUE Items | Excel Discussion (Misc queries) | |||
Accessing values in points collection of chart & conditional display | Charts and Charting in Excel | |||
Enumerating Printers | Excel Programming | |||
Compare Listbox values with Collection values | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |