Forum Discussion
Need help. Pivot table average adding decimal places to whole number
Riny_van_Eekelen Yes thank you I have updated the Average to zero decimal places. The table displays zero decimal places, the graph label displays zero decimal places. However, the actual graph of the value the bar illustrates multiple decimal place values. So for example two bars with label of "4" are different heights. See the attached example.
Cheryle2175 Interesting problem, but I haven't been able to solve it within the pivot table/chart. Tried Calculated Fields but that didn't do what I had in mind. A work-around could be to create a "helper" table that picks-up values from the pivot table and rounds these. Then, you create your chart from that helper table with rounded values. The attached workbook contains an example. Not sure if this is feasible or acceptable for you, though.
Riny_van_Eekelen Thanks, surprising their is not a way to control the average summarize value output.