Tabular - calculated member

  • Hi Guys, I have an excel file that is connecting to a tabular perspective. I am trying to add a calculated column to one of the tables, it appears to work in that I don't get an error message but I can't see the column in the pivot table field list. The syntax for my calculation is:

    Left([Product Hierarchy].[Product Hierarchy].[Item Number],4)

    To input this code I am going to PivotTable Analyze > MDX Calculated Member

    I have also refreshed the pivot table but the column doesn't exist. Does anyone know what I am missing?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply