
I am trying to do calculations on pivot table in excel 2013. I have the data in the powerpivot data model. The OLAP calcuation options are all greyed out so I can't use them. I can see the pivot table extensions options but when I open them there is no
calculations tab. So I am stuck. Any suggestions welcome. Thanks. DAve






Thx... such a bummer. Is there no way to create MDX expressions in 2013 workbook without a Sharepoint or SSAS server? Any workaround?



Not that I know of. No workarounds. You need to use DAX measures instead. Other than that it's a new language, you should be able to do just about anything you need in DAX.
I haven't tested what happens if you build a workbook in PowerPivot in Excel 2010 with MDX calculations then upgrade. Feel free to test. But that's not a good scenario since even if it worked, you would never be able to modify those MDX calculations again after
upgrading.



Great plug in by the way!
Thx... was hoping to leverage some of the statistical functions which are not supported by DAX (e.g. SLOPE, TREND, LINEST), and per the discussion
here.

