Calculating with N/A in pivot table source

If you want N/A to be shown as 100% in your Pivot Table then you may follow the below Steps:

Insert PivotTable.
Check all the PivotTable Fields.
Change the PivotTable to the classic layout (or keep the standard one if you prefer).
Click inside the PivotTable and Press Alt + A to select all PivotTable data.
Choose Home >> Styles >> Conditional Formatting >> New Rule.
Choose Format only cells that contain.
In Format only cells with, choose Cell Value, and equal to, then type N/A
Click the Format…
Choose the Number tab and Custom
Inside the Type field, insert 100%
Click OK.
This rule replaced all strings consisting (N/A) to 100%
If you add missing values to the table, nothing will change inside the PivotTable. If you want to apply changes, you have to click it with the right mouse button and choose Refresh.