Hello!

I'm working with two separate pivot tables pulling from two separate & very different data sources in order to calculate turnover. I was not able to create a calculated field via excel due to the data for my turnover % calculation coming from 2 separate tables so I have a manual % formula I've added beside each item I'm measuring that is using GETPIVOTDATA to pull in the values needed for the calculation

Prior to slicing the data, everything looks great. However, upon slicing the data (for example by area/location) the slicer removes a couple of rows due to no data being associated after the filter and I therefore end up with a few empty rows with the #REF! error

Does anyone know if there is a way to not have the data removed or shuffle around upon slicing? But rather just have it produce a 0 or another error message? I just need the formatting to stick so that my formulas beside the pivot table rows stay aligned