I'm trying to display data suppressed to display <5 as 0, whilst also rounding the values to the nearest multiple of 5.

I know the formulas to do this in tables however, as I would like to use 'Report Connections' with my slicers, all pivots need to be from the same data table.

Messed on with 'Calculated Field' on the PivotTable Analyze tab but to no avail.

Thanks