Concatenate field values into rows in a pivot table
Posted on 2014-03-18
I have a simple pivot table which displays sales by Customer by Year by Period.
The rows are
I would like to concatenate the Item Number & Description into one row to display the rows as
-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.