I am using Excel 2010 so I cannot add a calculated field to an OLAP Pivot. Is there a way I can use a cube function to do the same.
E.g. to have a single field that contains the combined value of two Measure fields
Something like =CUBEVALUE("Connection","{[Measure].[Cost Price] + [Measure].[Mark up]}")
Bookmarks