ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Decreasing number of Values in Pivot Tables Value List (https://www.excelbanter.com/excel-discussion-misc-queries/143459-decreasing-number-values-pivot-tables-value-list.html)

Rohan

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 !


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com