Pivot Table - Please help

[vidya1987]

Hi All,

I am trying to use Pivot table in one of excel sheet, containing a lot of data. I am very confused about where to incert fields.

Can somebody help?

here is my data

A B C D E F
Rows: Sales_Person_Name Customer_Name April May June Total
X A 1 2 3 6
X B 0 1 1 2
Y D 3 2 1 6
Y C 1 1 1 1

Now i need a pivot table where i can choose, which sales person has done how much business & which customer has given how much business, & also total of each months business,

Please help me..

 

[Trevor G]

Welcome to the forum,

Have you searched for a solution to your question? Something like utube will give you many tutorials that you can watch, pause and create.

Here is a link

http://www.youtube.com/watch?v=7zHLnUCtfUk