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



Use Sage ODBC driver into Access ..