Can anyone suggest how I could get rid of multiple rows for each data
element? I have multiple attribute fields (brought in as PivotTable rows)
each of which is currently taking its own row which is wasteful.

I would like all associated data to appear on a single row with the
summation (the "data" element) at the end.