Hi
I have a pivot table constructed with data from an external (Access) database. What's the best way to provide an 'others' category which sums all contributions less than a certain number?
Can I do this from within Excel, or do I have to change the Access data design in some way?
I have a pivot table constructed with data from an external (Access) database. What's the best way to provide an 'others' category which sums all contributions less than a certain number?
Can I do this from within Excel, or do I have to change the Access data design in some way?