Percent of Column

To display a value which represents the row’s percent of the column total, use the % of Column data function in the Pivot section. The data element to which the % of Column data function is applied must be numeric. If it is a non-numeric element, such as U Id, first modify the data element in the Query section by applying the Count data function to the element, i.e. U Id, on the Request Line.

  1. In Pivot section, populate the Outliner to display the desired data items.
  2. Add a Total column by selecting the appropriate column header tab (to the right of the column header) and pressing the sigma button (or right-click and select Add Totals).
  3. Alt-click on the Total column heading. This selects the Total column and values contained within it.
  4. Select Pivot menu, select Data Function and select % of Column (or right-click, select Data Function and select % of Column).

Last updated: October 15, 2013

Last updated: October 15, 2013