5 Replies Latest reply: Mar 15, 2018 12:09 PM by Jason Hendrickson RSS

    Exclude current row dimension from TOTAL expression in a table

    Jason Hendrickson

      I am working on an application comparing performance of employees to a group of peers in a table. Each row is dimensioned by the employee and contains a compliance rate SUM(numerator)/SUM(denominator) and is being compared to SUM(TOTAL numerator)/SUM(TOTAL denominator). However, this compares the employee compliance rate to the group's compliance rate including the employee in the current row. I would like to compare the employee to the group excluding the employee in the current row.