D
dwh425
After creating a pivot table, I am left with the lead category (furthes
to the left) that is summaried. Iv'e tried to cut and paste to give a
example.
Area Item
Asia CF1GB-80-380
CF1GB-80-520E
CF2GB-80-380
CF2GB-80-520E
CF4GB-80-380E
CF4GB-80-520E
CF512-80-380
CF512-80-520E
IR-437
PM-231
RW021-001
WALLET-231
Is there a way to set the pivot so it will fill the blank section
below Asia with "Asia"? Automatically, not by copy and pasting it in.
This used to be a feature in previous versions of Excel.
Please respond directly to [email protected] with the subject title o
PIVOT TABLE.
Thanks,
DWH425
to the left) that is summaried. Iv'e tried to cut and paste to give a
example.
Area Item
Asia CF1GB-80-380
CF1GB-80-520E
CF2GB-80-380
CF2GB-80-520E
CF4GB-80-380E
CF4GB-80-520E
CF512-80-380
CF512-80-520E
IR-437
PM-231
RW021-001
WALLET-231
Is there a way to set the pivot so it will fill the blank section
below Asia with "Asia"? Automatically, not by copy and pasting it in.
This used to be a feature in previous versions of Excel.
Please respond directly to [email protected] with the subject title o
PIVOT TABLE.
Thanks,
DWH425