G
Guest
I have the following data,
Name Amount
David 400
Homer 100
David 300
Homer 100
Sanjiv 600
How can I use a pivot table to aggregate the total the amount for each
person, but only show if the amount is greater than 500?
E.g.
Name Amount
David 700
Sanjiv 600
Name Amount
David 400
Homer 100
David 300
Homer 100
Sanjiv 600
How can I use a pivot table to aggregate the total the amount for each
person, but only show if the amount is greater than 500?
E.g.
Name Amount
David 700
Sanjiv 600