View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Martin Fishlock Martin Fishlock is offline
external usenet poster
 
Posts: 694
Default summarising page data

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.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"JohnW" wrote:

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