Excel Programming

An Excel Programmability blog by Gabhan Berry

Browse by Tags

Tagged Content List
  • Blog Post: Creating Custom Calculated Members and Sets in OLAP PivotTables

    If you are using PivotTables against an OLAP data source you may find it useful to be able to create your own custom, calculated measures and sets. These calculations are client-side meaning they exist inside Excel and you don't have to change the server-side OLAP cube. Excel does not enable you to...
  • Blog Post: Using Cell Text to Filter PivotTables

    Sometimes it would be useful to be able to use cells to select items in a PivotTable. For example, let's say we have a PivotTable containing a field called Region. Instead of using the filter dropdown to select the region from a list it would be nice if we could use a cell to specify the region. That...
Page 1 of 1 (2 items)