Tabular - calculated member

• Jim-S

  SSCommitted

  Points: 1823

  More actions

  August 6, 2024 at 12:45 pm

  #4442745

  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?

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  August 7, 2024 at 1:10 pm

  #4442988

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

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