summarising page data
 

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

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

summarising page data
 

Thanks for that Martin, I did a pivot table some time ago. I even forgot why
I was doing it. Your instructions should save me a bit of time.
Thanks again.

"Martin Fishlock" wrote:

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