Calcuations – XLCubed Blog ../../../ XLCubed Blog Wed, 01 May 2019 07:48:35 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Calcuations – XLCubed Blog ../../../ 32 32 Calculated fields are not available in an OLAP-based Pivot Table … ../../../2016/06/calculated-fields-are-not-available-in-an-olap-based-pivot-table/ ../../../2016/06/calculated-fields-are-not-available-in-an-olap-based-pivot-table/#comments Mon, 20 Jun 2016 09:22:51 +0000 http://blog.xlcubed.com/?p=4243 One of users biggest frustrations with cube connected PivotTables is that they can’t add calculated fields like they can with a regular PivotTable – the calculated field is greyed out on the ribbon. Data in the Pivot Table can be referenced elsewhere in Excel, but that makes the final report largely static in shape. It […]

The post Calculated fields are not available in an OLAP-based Pivot Table … appeared first on XLCubed Blog.

]]> ../../../2016/06/calculated-fields-are-not-available-in-an-olap-based-pivot-table/feed/ 1