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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enumerating PivotItems collection fails to display duplicate values
Maybe showing your code would help.
-- Regards, Tom Ogilvy "kirk" wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enumerating PivotItems collection fails to display duplicate values
Thanks for the follow-up Tom.
I ended up restructuring my code to work successfully. What I did was obtain the start and end rows of the pivot table, obtain the Excel column for the data I was previously fetching pivot items from, obtain the Excel columns for the necessary associated data, then just walk the range of rows from start to end to perform my business. Tom Ogilvy wrote: Maybe showing your code would help. -- Regards, Tom Ogilvy "kirk" wrote in message oups.com... 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. |
Reply |
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 |