Can't get my pivot table to produce two Grand Totals
I am trying to audit the stock provision of a client company and have extracted from Sage (and for fields marked * calculated) the following
Code
Description
Number in stock
Unit value
Stock value
Age (in years)*
Provision % *
Provision * (Provision % x Value)
I have used a pivot table to analyse this and it works fine - I want to use Age as a page field and have set it up with everything as rows except sum of Provision which is data
Ideally I want a total of Stock Value and of the Provision, but if I move anything into the data area Excel says I have to move a field to Page, Row or Column and there is no grand total for a row field.
I am using Excel 2003
I know I am missing something obvious - but what is it?
Chris Lloyd
- RTI Fees 285
- Where's our 10%? 259
- Driving sales growth 212
- Cost of converting property - who pays? 204
- CIS late registration 203
- EIS 200
- Accounting for gift vouchers - paid for and donated 192
- Break up basis accounting 187
- Accounts production software for business SSC 181
- Best structure 177
- High Income Child Benefit Tax Charge Error? 173
- iQor recovering HMRC debts again 152
- Mileage Allowance Payments - couple using the same car 136
- Dual income transfer of Personal Allowance 136
- SEIS and DeMinimus Aid 133
- Integrate accounts software with infusionsoft 131
- Is commission on sales always vatable? 129
- Property does not qualify for FHL, what is allowable? 118
- Loan Note, PIK and Corresponding Adjustment 116
- Employers NIC holiday paper application form 111



Use Sage ODBC driver into Access ..