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 |
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) |