Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5215
  • Last Modified:

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.
0
Paul G
Asked:
Paul G
  • 2
2 Solutions
 
Rob HensonIT & Database AssistantCommented:
If you went for Classic Display, the Item Number and item Description would be next to each other rather than staggered one below the other.

However, so would all the other Row Headers so you would end up with:

Customer name  |  Branch Name  |  Item Number  |  Item Description  |  Values

The | entries being the column breaks.

This would be gained by right clicking on the table and choosing Pivot Table Options, then the Display tab.

The only other way that I know of would be, as you suggest, concatenating in the source data.

Thanks
Rob H
0
 
Paul GAuthor Commented:
Messy, but it seems that I will have to use my original suggestion in the source data.
Thanks anyway
0
 
Paul GAuthor Commented:
Not a real solution to my question
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now