Pivot tables and drop-down lists

[lorentzen]

I want to create a pivot table that summarizes expences in different
categories. To do this I use a drop-down list containing these
categories, something like this:

category expence amount

fun beer 10
fun trip to the movies 20
insurance life insurance 40
...

In the case of creating a pivot table summarizing over the categories
how do i include unused categories?

Thank you !

 

[Guest]

L --

In order to make a good pivot table, you need some fairly standard headings.
I'd suspect your 'category' entries are pretty standard, but your 'expence'
listings seem more like descriptions. To make a pivot table, get your long
table of listings. Click on one of the cells, then click Data>PivotTable.
The instructions are pretty straightforward. When the new page opens up,
just drag your headers where you want them to go, and drag your 'amount' into
the central data field. You can drag multiple column and row headings and
change the order. If you don't like a particular column or row header, just
drag it back to the field listing where you got it.

HTH

 

[Debra Dalgleish]

In the source table, you could add at least one record for each
category, and leave the amount blank, or enter a zero.