Office 2007: Pivot Table to SSAS why menu item "Options"->"Formulas" is disabled?

V

vimas

I am using Excel 2007 with SQL Server Analysis Services 2005 SP2. I want to
create calculated measure based on other measures, but I cannot do this for
Pivot table. If I go to menu "Options"->"Formulas" I can see that it is
disabled. Same menu is enabled if I create Pivot table based on cells in
sheet.

How can I create caclulated measure for Pivot Table based on SSAS?

Thank you
 
E

Echo S

I suspect you'll have better luck getting this answered over in the Excel
groups. Try news://msnews.microsoft.com/microsoft.public.excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

- Excel 2007: Pivot Table to SSAS why menu item "Options"->"Formulas" is disabled? 0
Excel 2007: Pivot Table to SSAS why menu item "Options"->"Formulas" is disabled? 0
Excel 2007+AnalysisServices2005SP2: Pivot Table to SSAS why menu item "Options"->"Formulas" is disab 0
Menu Item Options -> Formulas Disabled for Pivot tables. 2
Excel 2007 with SQL Server Analysis Services 2005 0
Is it possible to intercept pivot table SSAS query or extend SSASprovider? 0
Excel 2007 pivot tables - calculated fields and SSAS cube 3
Create set based on column items feature in Pivot Tables 2010 1

Top