software

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 !--
lorentzen
------------------------------------------------------------------------
lorentzen's Profile: www.excelforum.com/member.php...oamp;userid=33762
View this thread: www.excelforum.com/showthread...hreadid=535342L --

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 Datagt;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

quot;lorentzenquot; wrote:

gt;
gt; I want to create a pivot table that summarizes expences in different
gt; categories. To do this I use a drop-down list containing these
gt; categories, something like this:
gt;
gt; category expence amount
gt;
gt; fun beer 10
gt; fun trip to the movies 20
gt; insurance life insurance 40
gt; ...
gt;
gt; In the case of creating a pivot table summarizing over the categories
gt; how do i include unused categories?
gt;
gt; Thank you !
gt;
gt;
gt; --
gt; lorentzen
gt; ------------------------------------------------------------------------
gt; lorentzen's Profile: www.excelforum.com/member.php...oamp;userid=33762
gt; View this thread: www.excelforum.com/showthread...hreadid=535342
gt;
gt;

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

lorentzen wrote:
gt; I want to create a pivot table that summarizes expences in different
gt; categories. To do this I use a drop-down list containing these
gt; categories, something like this:
gt;
gt; category expence amount
gt;
gt; fun beer 10
gt; fun trip to the movies 20
gt; insurance life insurance 40
gt; ..
gt;
gt; In the case of creating a pivot table summarizing over the categories
gt; how do i include unused categories?
gt;
gt; Thank you !
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html