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.
