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

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

Last edited: