excelkitty
New Member
- Joined
- Jan 27, 2005
- Messages
- 1
Hi, I know this question has been asked, but the solution given does not work in my case.
I am writing vba to create a pivot table (sample data below) where Player will be the rowfield, and Game will be the Columnfield. The data section will display the max of Score. Along with Score, I also need to display the Location in the data section (eg 8A should be displayed for the first record).
At first I was thinking about adding Location as one of the rowfields or columnsfields but it will not work in this case since one user can have multiple locations and one game can also have multiple locations.
I am stuck, any suggestion will be very much appreciated.
Sample data:
Player/Game/Score/Location
--------------------------------
UserA/GameA/8/BuildingA
UserB/GameA/10/BuildingA
UserA/GameB/6/BuildingC
UserC/GameB/6/BuildingB
UserD/GameA/10/BuildingC
UserD/GameC/10/BuildingC
I am writing vba to create a pivot table (sample data below) where Player will be the rowfield, and Game will be the Columnfield. The data section will display the max of Score. Along with Score, I also need to display the Location in the data section (eg 8A should be displayed for the first record).
At first I was thinking about adding Location as one of the rowfields or columnsfields but it will not work in this case since one user can have multiple locations and one game can also have multiple locations.
I am stuck, any suggestion will be very much appreciated.
Sample data:
Player/Game/Score/Location
--------------------------------
UserA/GameA/8/BuildingA
UserB/GameA/10/BuildingA
UserA/GameB/6/BuildingC
UserC/GameB/6/BuildingB
UserD/GameA/10/BuildingC
UserD/GameC/10/BuildingC