Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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 !
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where has my field list gone for my Pivot Tables? Michael S Excel Worksheet Functions 5 May 22nd 07 03:15 AM
Pivot Tables - Ranking Values Jeff Reese Excel Discussion (Misc queries) 1 May 1st 07 03:44 PM
Pivot tables - text rather than number? JoFo Excel Worksheet Functions 0 August 9th 06 12:29 PM
Pivot tables with zero/null values Todd1 Excel Discussion (Misc queries) 4 March 28th 06 12:45 PM
Supress Zero Values on Pivot Tables AROR Excel Discussion (Misc queries) 0 April 21st 05 01:23 AM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"