Hi..I m using Excel 2010. While creating a pivot table and applying values filters (Top 10 Sales), when I apply a slicer for region, I don't get Top 10 values when a particular region is selected. When all regions are selected only then the top ten values appear. Can u guide me through this.
Solved by K. B. in 11 mins