View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rohan Rohan is offline
external usenet poster
 
Posts: 15
Default Decreasing number of Values in Pivot Tables Value List

Hye Friends,
Few days back I created a cube in SQL 2005 Analysis
Service, which I am accessing using Excel's Pivot table. Unfortunately the
Cube contains large number of Dimensions & so the Field List which is getting
displayed in Excel is quiet huge.
I wanted to know if there is a way I can prevent the user
from seeing all the Dimensions in the Field List & only show him a selected
few which might be important.

Thanks in advance,
Regards,
Rohan !