pivot tables – 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 pivot tables – 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 Data sources for Excel dashboards: avoid spreadsheet hell ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/#comments Sun, 25 May 2008 23:00:20 +0000 http://blog.xlcubed.com/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ This is the first of two twin posts where we’ll discuss the alpha and omega of Excel dashboards: data access and dashboard publication. These are two weak areas in Excel, and they should be approached carefully when planning for a new dashboard. Let’s start by reviewing the available data access options. Copy / Pasting data […]

The post Data sources for Excel dashboards: avoid spreadsheet hell appeared first on XLCubed Blog.

]]> ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/feed/ 3