For a multilevel pivot report that has multiple fields used for the rows, if the fields do not have distinct values then the rows for the totals go out of alignment. See attached screenshot.
Steps to Reproduce
- Rename Beth Anglin to Bud Richman (changing first and last names only), there should now be two users named Bud Richman who are assigned incidents.
- Create a multilevel pivot report on the Incident table
- Columns - State
- Rows - Assigned to, Assignment Group
Note that all total rows after Bud Richman are off by one user (if you mouse over the counts, the assigned to will be the previous user)
upgrade to a version where fix is available
Related Problem: PRB1177784