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:
[TABLE="width: 1185"]
<colgroup><col><col><col span="7"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Ave structures per bottle [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team1[/TD]
[TD="align: right"]0.50[/TD]
[TD="align: right"]0.67[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]0.67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team2[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]0.67[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ave structures per operator [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.75[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team2[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]1.5[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total Ave structures per bottle [/TD]
[TD="align: right"]0.50[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]1.75[/TD]
[TD="align: right"]0.67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total Ave structures per operator [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 1185"]
<colgroup><col><col><col span="7"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Ave structures per bottle [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team1[/TD]
[TD="align: right"]0.50[/TD]
[TD="align: right"]0.67[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]0.67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team2[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]0.67[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ave structures per operator [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.75[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team2[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD="align: right"]1.5[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total Ave structures per bottle [/TD]
[TD="align: right"]0.50[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]1.75[/TD]
[TD="align: right"]0.67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total Ave structures per operator [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?