Hi there, I’m trying to create a pivot table, and finding it quite tricky. So I have all the information that I need but I don’t know how to set it up. I have the following headings: Group, Item Number, Description, Location I would like to convert the table to the below layout. Separating the location: Group, Item Number, Description, Location A, Location B, Location C, Total I’ve got a ‘Joiner’ and have linked in straight to a ‘Pivoting’ node. Is this correct? Any help would be great.

Pivot Table

izaychik63 November 22, 2018, 2:06am 2

Look at example: