I'm having problem with the top x filter. What I'd like to see is the top 5 product of 2012. All products have values for 2012 but sometime does'nt for previous years. The issue is product 2 from Germany. When I filter for top 5, this product should be third of five but simply disapear. Seems like excel is checking much more than the 2012 values... Tried to put 0 in empty cell in options with no luck. Same issue with 2007 or 2010 version of Excel.
Default sort are:
1) by year ascending
2) by product value of 2012 column
The attached workbook is a scale down version but show you exactly the problem.
Many thanks!
Bookmarks