Pivot like reporting

[cheneric86]

I've created a pivot table in a dashboard interface and I'm trying to summarize cost for projects. Each record is a deliverable which has a corresponding "Brief" that it's tagged to. Each deliverable also has a cost associated with it. Both "Brief" and "Cost" fields are lookups from another table.

The pivot table:

• Rows: Brief
• Columns: Deliverable Type
• Summarize by: Field
• Field: Cost
• Summary type: Sum

Unfortunately, the pivot table just shows up completely empty. I created the same pivot table as an extension and that worked perfectly. I can't seem to figure this one out.

Also, the Cost field is set as "currency" in the lookup table, if that's important.