tommatthews
New Member
- Joined
- May 28, 2015
- Messages
- 1
I have created a Pivot table from a table. The fields in the PT are Team, Member and Amount. Some members are on a team and some are not. I want to sort the PT descending amount by team. I want to print subtotals by team but no subtotals for Members. I do not know how to structure the PT to dot his. Here is an example
Data Table
<tbody>
</tbody>
Pivot Table
<tbody>
</tbody>
Any thoughts on how I can do this would be greatly appreciated. Thanks, Tom.
Data Table
Team | Member | Amount |
TM | Tom | 10 |
Wayne | 20 | |
TM | Donna | 25 |
Jim | 40 |
<tbody>
</tbody>
Pivot Table
Team | Member | Amount |
Jim | 40 | |
TM | Tom | 10 |
Donna | 25 | |
Total TM | 35 | |
Wayne | 20 |
<tbody>
</tbody>
Any thoughts on how I can do this would be greatly appreciated. Thanks, Tom.