Creating Custom Calculations in Excel with Pivot Table Extensions
User Rating: / 0
PoorBest 
Written by Paul te Braak   
Tuesday, 05 March 2013 22:32

One of the biggest hurdles that users are faced with when using Pivot Tables is that all measures and dimensions must be defined within the cube. Having the defined data available is really convenient for drag and drop analysis however in most situations, the users requirements can quickly outgrow the bounds of the definition of the cube. I want to see such and such in my data is the usual type of requirement. Sure, developers and report writers can create calculations but what about users - the people that need to use the data? This post looks at OLAP PivotTable Extensions, a tool which increases the usability of pivot tables for end users.

Read more...

 

Tags: excel, mdx, tool
 

XL Cubed