Processing
 

Excel 2013 MDX OLAP PivotTable Extension: Not Able to see Calculations tab

28/08/2016 16:24#1

RARascon

Member

Joined at: 6 months ago

Post: 1

Thank: 0

Thanked: 0

I just recently learned about OLAP PivotTable Extensions, and after I installed the add-in, as well as the PowerPivot add-in, I still don't see the option to add Calculations in the OLAP Pivot Table Extensions window.

Is there something I'm missing?

I need this because I found out that after I connected to an Access db that I can no longer create Calculated fields from the pivot table. The table is too large to store in the Excel file.

Thanks!

29/08/2016 07:10Top#2

whytheq

Member

Joined at: 12 months ago

Post: 76

Thank: 0

Thanked: 0

Are you connected to a cube?

Access is not olap. Try connecting a vanilla pivot table to an olap cube - does the calculations section now appear?

Similar articles

Excel More conditions in one formula?

6 months ago - Reply: 2 - Views: 172

Get Workbook reference from Open File dialog

6 months ago - Reply: 2 - Views: 131

Add Calculated Field To Pivot Table

6 months ago - Reply: 0 - Views: 7

Nested IF Functions in Excel not working

6 months ago - Reply: 3 - Views: 164

Formulating Date in Excel 2013

7 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

7 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

7 months ago - Reply: 1 - Views: 23

excel search and copy in/from another file

7 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

7 months ago - Reply: 0 - Views: 6

Excel static conditional formatting area

7 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re