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

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

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

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

"vimas" <nobody@nowhere.com> wrote in message
news:uEx$jVcVHHA.5060@TK2MSFTNGP06.phx.gbl...
>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
>
>