Creating Pivot table

[psinghania]

I have 2 set of data  Current year and previous year compiled in one file which has details for customer , sales reps.

I want to summarize this details for Qty, Sales , GM and GM rate .

While using cross tab I can summarize only for one column i.e. Qty . I need for Sales, reps and GM rate also.

This is the pivot I want:

This is the source data:

Can anyone please help me.

[benakesh · Accepted solution]

Hi @psinghania ,

Create name value pairs  for  Qty , sales , GM  etc   and   use  cross tab. 

[cplewis90]

I have attached a workflow that accomplishes this with some sample data I made up. Same column names as your file