Grumpy88
Member
Hi. I need some help with the attached extract from an Excel database please: https://dl.dropboxusercontent.com/u/92056659/Database.xlsm
This is part of a much larger database tracking club cricket player performances. What I specifically need is a way for the "Indiv Fielding Pivot Table" tab to pick up the total number of innings in which any given fielder was the wicket-keeper (as indicated in column Q of the "Indiv Performances" tab. This should then be displayed in another column on the pivot table alongside the fielder's catches and stumpings.
I figure that a formula in a helper column in the "Indiv Performances" tab will be necessary for the pivot table to latch onto, but haven't been able to figure out one that works.
If would also be great if someone could add a functional column to the same pivot table that specifically counts the number of stumpings effected by each fielder (I've only been able to infer this on the "Indiv Fielding Pivot Table" tab as being the difference between the catches held and the total dismissals effected for each fielder.
Thanks!
This is part of a much larger database tracking club cricket player performances. What I specifically need is a way for the "Indiv Fielding Pivot Table" tab to pick up the total number of innings in which any given fielder was the wicket-keeper (as indicated in column Q of the "Indiv Performances" tab. This should then be displayed in another column on the pivot table alongside the fielder's catches and stumpings.
I figure that a formula in a helper column in the "Indiv Performances" tab will be necessary for the pivot table to latch onto, but haven't been able to figure out one that works.
If would also be great if someone could add a functional column to the same pivot table that specifically counts the number of stumpings effected by each fielder (I've only been able to infer this on the "Indiv Fielding Pivot Table" tab as being the difference between the catches held and the total dismissals effected for each fielder.
Thanks!