Ok, you've got the codes and I'm assuming what you are asking is how do you sum for each code?
You will have dragged each entry (Gross, Net and VAT) to the Values area of the pivot table field list.
If they are shouwn as anything other than sum of (quite often the default is count) left click on the field, click on value field settings and click on sum.
you will then have each nominal with the sum of each of the values against it.
hope that was what you werre asking,
kind regards,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
If only someone out there paid people to just play with spreadsheets all day I'd be happy as a pig in muck Neil.
Unfortunately, it seems that over the years it's become an expected add on skill rather than a skill in it's own right. People don't even put it on their CV's anymore as it's just expected that you will have it.
As for growing up... You don't want to do that, it's a trap.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
