Michael Purdham
asked on
Concatenate field values into rows in a pivot table
I have a simple pivot table which displays sales by Customer by Year by Period.
The rows are
-Customer Name
-Branch Name
-Item Number
Item Description
I would like to concatenate the Item Number & Description into one row to display the rows as
-Customer Name
-Branch Name
-Item Number & " " & Item Description
Clearly I could calculate another column in the source data but would be better if I can do this in the pivot table.
Thanks.
The rows are
-Customer Name
-Branch Name
-Item Number
Item Description
I would like to concatenate the Item Number & Description into one row to display the rows as
-Customer Name
-Branch Name
-Item Number & " " & Item Description
Clearly I could calculate another column in the source data but would be better if I can do this in the pivot table.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER