Create a custom slice on a calculation to override the selection used to calculate a number.  Displays a percentage between the current value and the All value.

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 a dimension within the Filters section of the report.
  • Select a parent member for the dimension, such as All, and choose OK.