Pivot Table Calculated Fields

I'm using Excel 2007, and I have a collection of rows that I'm treating sort of as a 'database' - a collection of rows, each of which is an independent record, and I'm using functions such as DCOUNT() all over the place to provide different ways of drilling down into this data.

I'll call 3 of the particular fields in this collection of records "Category", "Item", and "Rank".

What I want is a PivotTable where the Rows are all of the "Item" values, grouped by "Category". All values of the "Rank" field should then be listed as the column headers, and the value for a particular row / column is the # of records with a particular rank. Example:

Please Login or Register  to view this content.

I want this to be displayed like this:

Please Login or Register  to view this content.

I'm having trouble getting this to work. I can get the table layout correct, but all the cells in the "inside" of the PivotTable are empty. I figured out that I can add a new calculated field using Options -> Formulas -> Calculated Fields. But this just puts a bunch of 0s in the cells, and I can't figure out how to make it display the value I'm interested in.

Any help appreciated.

Like attached?

See here: http://www.techonthenet.com/excel/pi..._cells2007.php

for how to show 0's when empty.

You can sort descending from the Home menu|Editing section.

Isn't the one I added here what you want? (which is the same as I had before and seems to follow your requirements)....

Okay, in the meantime, please mark this thread solved. Then a start a new thread if you have a new question.