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: http://www.excelforum.com/member.php...o&userid=33762
View this thread: http://www.excelforum.com/showthread...hreadid=535342