If you notice that the salary calculations are completely missing in the dashboard (Salary distribution report, salary grade report and pay equity report), then the following could be the main root cause.
If the Salary data has cells which appear to be blanks but they are actually empty strings (Excel considers them as text and not numbers and so it is not able to calculate median salary, total salary, etc.
Excel needs all salary values to be numbers or totally blank).
Or after pasting the data into our template AND BEFORE REFRESHING DATA (if you hit the refresh, then pivot tables are updated and they will break due to having empty strings), please do the following
Note: If you have already hit the refresh button by mistake and all the pivot tables are broken, we recommend just starting again with the empty original template and enter your data again. If you need assistance, please contact us.
- Filter the Salary column by selecting only blanks as shown in the image below.
- Then select all such cells in the salary column.
- Hit the delete key. This clears all the values and makes them truly blank.
Now, refresh the calculations from the menu DATA ---> REFRESH ALL.
This should fix the issue with salary calculations.