Roundup Summary from Pivot Block


#1

In Excel, I can insert a pivot table from a table in excel and add a formula field that “roundup” the sum from the pivot table. Can this be done using the Pivot table block?

For example: I have 4 unique records with a Sum of items from another table
Peter 4.14
Mary 3.2
Paul 7.3
Matthew 5.4

I want the above numbers to be rounded up to the next nearest number, 5, 4, 8 and 6.

Clearly my table has many records, hence the reason to automate if possible.