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

Hi @psinghania ,

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

pivot1.yxmd