Pivot Table Customized Formulas
Hi,
My excel pivot table is connected to Analysis Services Cube. However, I can see that if i'm connected to AS cube, the Formulas menu in Pivot Table Tools Options is disabled. Thus, I can't create an external formula, apart from what I have in the cube. I tried also creating a pivot table in which the data source is an excel sheet. The Formulas menu is enabled and I can create a calculated field. Why is it if I'm connected in Analysis Cube that it is disabled? Anything I missed out to do? Thanks a lot.... |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com