M
Matt Dawson
Having constructed pivottable, I have a percentage field, which until i added
more fields, it found the percentage of either quote sent or rejected in
terms of the total. With these extra fielsd it just gives me either 0% or
100% as it lists every record.
When i go into the pivottable itself, I need to list the percentage but it
gives it as a sum of the percentages i.e. 100% plus 100%. what I need is a
summary per country and then an overall total and I cant seem to get that.
Any ideas?
Matt
more fields, it found the percentage of either quote sent or rejected in
terms of the total. With these extra fielsd it just gives me either 0% or
100% as it lists every record.
When i go into the pivottable itself, I need to list the percentage but it
gives it as a sum of the percentages i.e. 100% plus 100%. what I need is a
summary per country and then an overall total and I cant seem to get that.
Any ideas?
Matt