Rounding (removing decimals) from Pivot Table results

Hello all,

Have an interesting scenario - a report is generating speeding violations for both US and Canada. When manipulating the data that comes from Canada, I can convert to metric easily enough, but it shows the speed limit as 79.99999. I can change the cells to only display a number with no decimals and it automatically rounds up the values. Done.

I create the Pivot Table off that data set, but when I double click the field to see the expanded selection in a new sheet, it shows the data without the rounding, decimal adjustments. Is there a way to prevent that from happening?

I'd share the Excel sheet, but it's got proprietary company/client information...sorry

My partial result to solving the problem is the ROUNDUP function, then copying values into a new column

roundup.png

The problem still exists when double-clicking the count of instances in the PT - the full data set for that range of data is still shown, and I don't want the original numbers to be visible - just the rounded total. Make sense?

I've already done the ROUNDUP function, but thanks for the recommendation. That's not the source of the problem. The problem exists when you double-click on the # of violations from the Pivot Table. When performing that task, it opens up the full instance details in a new sheet and displays the original source values. I've sanitized the sheet for a sample version to illustrate what I am talking about. Double click on cell B6 in the attached sheet and you'll see what I am talking about:

Column E in the new tab of data shows the exported speed limit - that's what I am trying to hide...make sense?