Setting a custom slice on a calculation part allows you to override the selection used to calculate a number. A common use of this is to display a percentage between the current value and the "All" value for row. 

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 a parent member for the dimension, such as All, and choose OK.