I want to use a pivot table for a monthly timesheet. As I work on a task I
record the hours spent on that Task as "Time" in my source data. The pivot
table shows me the Time spent on each Task per Month. The pivot table has a
calculated field with the following formula:

=ROUNDUP(Time*Rate,-1)

The gives me a $ figure rounded up to $10 multiples.

However, the pivot table totals appear not to sum the rounded up values,
rather they appear to sum the source data and then round up. This results in
column totals that do not match the sum of the rows below them. Is there a
workaround for this?