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?
[TABLE="width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD]ID01[/TD]
[TD]Mark
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]ID02[/TD]
[TD]Ricky[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]ID01[/TD]
[TD]Mark[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]ID03[/TD]
[TD]Peter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]ID04[/TD]
[TD]Gino[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]ID03[/TD]
[TD]Peter[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD]ID01[/TD]
[TD]Mark
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]ID02[/TD]
[TD]Ricky[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]ID01[/TD]
[TD]Mark[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]ID03[/TD]
[TD]Peter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]ID04[/TD]
[TD]Gino[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]ID03[/TD]
[TD]Peter[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Much thanks
Last edited: