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.
