MDX: subtract subtotal from total

• Ian C0ckcroft

  Hall of Fame

  Points: 3373

  More actions

  February 22, 2016 at 12:23 am

  #324933

  Hi guys,

  i have a measure that calculates hours worked on a task.

  task fall under projects:

  INTERNAL,ENHANCEMENTS, SUPPORT

  the roll up works, but i need to display INTERNAL subtotal, I then need to subtract the INTERNAL subttotal from the total

  Is this possible in MDX?

  cheers

  Ian

  Ian Cockcroft
  MCITP BI Specialist

• Martin Schoombee

  SSCoach

  Points: 19128

  More actions

  February 22, 2016 at 7:40 pm

  #1860257

  It should be possible. Can you post the structure of the dimension members/hierarchies in question as well as the measures?