Hi there, I am creating a sales analysis pivot report for products sold by
each retailer in a state/province, but some of the same customer names are
repeating more than once in the given state/prov. How can I consolidate the
retailers, so that there name only appears once in the state/prov, with its
entire total qty? You help is appreciated.
--
-RDH