Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table grouping of redundant data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table grouping of redundant data
If the names are the same, they should group automatically. Perhaps some
have an extra space character or two, at the end of the name, in the source data. RDH wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
Grouping a data field in a pivot table | Excel Discussion (Misc queries) | |||
Grouping data in pivot table columns | Excel Discussion (Misc queries) | |||
Pivot table grouping of data | Excel Discussion (Misc queries) | |||
grouping data in a pivot table | Excel Discussion (Misc queries) |