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.
Solved! Go to Solution.