Incorrect total of calculated field in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Mark

That is the way that calculated fields work inside Pivot Tables.
Instead, add a column to your source data with the Time*Rate calculation,
give it a heading and extend your data range to include this new column.
Use this new field in the PT rather than the calculated field.
 
Back
Top