summarising page data

[JohnW]

I have a excel sheet that is similar to this on each row...
Suburb Postcode Detail1 Detail2 Detail3
There can be many suburbs to one post code & Details contain ammounts

The question is, I would like to produce a one page summary report for each
postcode that has sum of its detail values

I got as far as filtering unique for unique values, and couldnt go any
further.

Any help would be appreciated,
John

 

[Martin Fishlock]

Try pivot table report from the data menu.

Put the postcode in the row
put te detail1..3 in the data
You may need to move the details around as it likes to stack them but if you
pick up the data and move it to the right it should put them in columns.

You may also need to change it from count to sum this is done on the pivot
table toolbar and select wizard ( with the cell pointer in the pivot table)
then select layout and click on each of the three details and change them to
sum if needed.

You can also change the row and column totals if needed.

you can them make a chart from right clicking in the pivot table and
selecting pivot chart.