ExcelBanter - Excel 2007 with SQL Server Analysis Services 2005

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 with SQL Server Analysis Services 2005 (https://www.excelbanter.com/excel-discussion-misc-queries/240442-excel-2007-sql-server-analysis-services-2005-a.html)

Salles

Excel 2007 with SQL Server Analysis Services 2005

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

All times are GMT +1. The time now is 03:00 PM.