pluginbabies
New Member
- Joined
- Jul 14, 2009
- Messages
- 1
Ok, let me explain my problem, i'm completely stumped!
I have a spreadsheet with a column containing the following values (names changed for confidentiality!)
OrangeGreen
GreenRed
BlueRed
I have a pivottable based on this data, with the field containing these values in the page area (i've tried it in the row area and the same happens). When i open the filter dropdown box i get the following options
BluuRed (this was previously in the original data as a misspelling, but now corrected)
BlueRed
BlueRed2
GreenRed
and OrangeGreen is missing...very strange!
If i then do a 'show details' to see what the underlying data is, the values are correct per the original data, but don't tie through to the values shown in the pivottable, however they map as follows
BluuRed >>> GreenRed
BlueRed >>> no data
BlueRed2 >>> BlueRed
GreenRed >>> OrangeGreen
Anyone seen this before????
I have refreshed the data numerous times!!
I have a spreadsheet with a column containing the following values (names changed for confidentiality!)
OrangeGreen
GreenRed
BlueRed
I have a pivottable based on this data, with the field containing these values in the page area (i've tried it in the row area and the same happens). When i open the filter dropdown box i get the following options
BluuRed (this was previously in the original data as a misspelling, but now corrected)
BlueRed
BlueRed2
GreenRed
and OrangeGreen is missing...very strange!
If i then do a 'show details' to see what the underlying data is, the values are correct per the original data, but don't tie through to the values shown in the pivottable, however they map as follows
BluuRed >>> GreenRed
BlueRed >>> no data
BlueRed2 >>> BlueRed
GreenRed >>> OrangeGreen
Anyone seen this before????
I have refreshed the data numerous times!!