Hi All,
Very new to Power tools . i have been experimenting on this issue which i can deal in Sumifs.
How can I show in Pivot table that Mark has 30 total, Ricky 15 Total, Peter 18 Total and Gino has 5?
<tbody>
</tbody>
Much thanks
Very new to Power tools . i have been experimenting on this issue which i can deal in Sumifs.
How can I show in Pivot table that Mark has 30 total, Ricky 15 Total, Peter 18 Total and Gino has 5?
10 | ID01 | Mark | |
15 | ID02 | Ricky | |
20 | ID01 | Mark | |
10 | ID03 | Peter | |
5 | ID04 | Gino | |
8 | ID03 | Peter |
<tbody>
</tbody>
Much thanks
Last edited: