Nederbrakel
New Member
- Joined
- Jan 23, 2019
- Messages
- 11
I have a pivot table where I put the value variables in the rows. The row definition looks like this:
Ʃ Values
Team
Team is a column with team names. The defined values in the example below are 'Ave structures per bottle' and 'Ave structures per operator'
The result is something like this:
<colgroup><col><col><col span="7"><col></colgroup><tbody>
</tbody>
The totals for the different value fields are all at the bottom of the pivot table. Is there a way to get the totals for each value field under its section?
Ʃ Values
Team
Team is a column with team names. The defined values in the example below are 'Ave structures per bottle' and 'Ave structures per operator'
The result is something like this:
Ave structures per bottle | |||||||||
Team1 | 0.50 | 0.67 | -- | -- | -- | -- | 0.67 | ||
Team2 | -- | -- | 0.67 | -- | -- | -- | -- | ||
Ave structures per operator | |||||||||
Team1 | 2 | 0.75 | -- | -- | -- | -- | 3 | ||
Team2 | -- | -- | 1.5 | -- | -- | -- | -- | ||
Total Ave structures per bottle | 0.50 | 0.67 | 0.67 | 0.00 | 0.00 | 1.75 | 0.67 | ||
Total Ave structures per operator | 2 | 0.75 | 1.5 | 1 | 2 | 1 | 3 |
<colgroup><col><col><col span="7"><col></colgroup><tbody>
</tbody>
The totals for the different value fields are all at the bottom of the pivot table. Is there a way to get the totals for each value field under its section?