I have a dimension containing around 15000 items. In Excel, when I drag this dimension to the pivot table area, it outputs the result within 1 mins. Then, I click only five items to display and "un-click" the others. Now, it requires 9 mins to display. This speed is very slow. Does anybody know the result and how can I improve the speed? Thanks a lot!