Hi All,
Baffled by this - have no idea why this is happening, here is the relevant part of my code:
The code breaks when it gets to the last 2 lines (in Red) because the pivot table does not show the filter options to filter by "Greater Than", in fact it only shows the option to use the Top 10 and nothing else. Here is a screenshot attached.2014-02-13 16_07_23-Microsoft Excel - Exception Reporting.xlsm [Compatibility Mode].png
Any ideas why this is?
I had created the same pivot table from the same data without VB before and that showed the other filter options. the only difference I could find is that in that the data fields are called "Values" but in this the heading says "Data" - attached is a screenshot of the manual pivot.
2014-02-13 16_26_05-Microsoft Excel - Zakhiem Citi Report 10 2013.xlsm.png
All help is greatly appreciated.
Thanks.
Bookmarks