Pivot Table - Sum column

[OceanIT]

Hi all

Struggling with something that is probably really easy to do, but can't get my head around it.

Basically I've downloaded from our Accounts system all products sold to customers and the sales price.

Pivot table shows these products, the QTY sold (sum) and the Sales Price (sum) but doesn't show the customer column.

What I'm now trying to do is add another column to the end of the Pivot Table so I can get the Sales Price (sum) for just a specific customer to compare to the overall Sales Price (sum)

I've managed to use a SUMIF in the data table which totals the Sales Price where the criteria is product code and the specific customer.
This value then appears in every row where that product has sold to the customer - and when this column is added to the Pivot table, it sums them all together which is not what I want to do.

Any ideas? Thanks in advance
Luke

 

[OceanIT]

http://oi60.tinypic.com/1zq91zc.jpg

Hopefully this makes sense. So I have my "Values" of QTY Sold and NET £ , then to the right of this I'd like the value for the specific customer only.

 

[steve the fish]

Will need to see the raw data to help.

 

[OceanIT]

I now need to go into a meeting to discuss these figures. I cant attach the data as its confidential; I had to quickly make up those items on the one I attached

will try and get something over to you later today

 

[steve the fish]

Something like this does what you want but needs a bit of understanding to alter it to requirements:

=SUMPRODUCT(--(RawData!A1:A1000="Customer Name"),--(RawData!D1:D1000=D3),RawData!C1:C1000)

Where RawData!A:A houses the customers, RawDataD:D houses the product codes and RawData!C:C the sales net.