Sums in interface pivot table not working

Topic Labels: Data Interface Designer
116 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0