Setting a custom slice on a calculation part allows you to override the selection used to calculate a number. A common use is to display a delta or percentage between the current value and a reference member.

For the "% Of Parent" calculation an MDX: statement is needed so that the selection is dynamic with every row. 

Create an MDX statement, such as ="MDX:[Geography].[Geography].CurrentMember.Parent", in a cell outside of the grid report.

Create a custom calculation

  • Double-click the column heading, such as, ΔPY% to open the Design Table window.
  • Select the Columns tab and the first ΔPY% column. 
  • Change the 
    • Name to IBCPct
    • Display to Number
    • Formatting to Actual
    • Header 2 to % of All and the dimension's name, such as % of All Products.
    • Expression to Percentage
  • Set the Calculation for Part 2 to blank.
  • Enable Additional filters.
  • Select the first down arrow and choose the dimension on rows such as Geography or Entity.
  • Select the Excel range icon.
  • Choose the cell containing the MDX statement, such as V2, and choose OK.