Menu Item Options -> Formulas Disabled for Pivot tables.

R

Ruchit Shah

I am using Excel 2007 with SQL Server Analysis Services 2008. 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.

Can anyone let me know how to enable the "Formulas" in Options for Pivot
table.

Thanks
 
R

Roger Govier

Hi

As far as I am aware, there is no method of using Formulas in a PT, when the
source is based upon an OLAP cube.
 
D

David Heaton

Hi

As far as I am aware, there is no method of using Formulas in a PT, when the
source is based upon an OLAP cube.

--
Regards
Roger Govier








- Show quoted text -
Click to expand...

Hi,

Roger is correct.

Formulas are not available when the pivot table is based on an OLAP
cube.

Regards

David
 

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
Excel 2007 with SQL Server Analysis Services 2005 0
Office 2007: Pivot Table to SSAS why menu item "Options"->"Formulas" is disabled? 1
Pivot Table Solve Order 1
Limit pivot functionality 0
Pivot Tables in Excel 2007 vs 2003 1

Top