Adding a Calculated Field in a Pivot Table using OLAP CUBE

[Sundance_Kid]

Hi,

Hope I have posted in the correct forum.

Have a pivot table using the OLAP Cube for the data.

I want to add a calculated field, the option to select Calculated Field/Item is not there.

Looks like there is possibly some potential option around MDX but I can't figure out is it possible to add a created field using the MDX options.

Does anybody have any pointers or links to helpful articles or videos?

Thanks