What version of Tableau are you using? There was a an issue in an earlier version for Tableau Desktop that was fixed in later releases.
More information found here: Missing Fields and Unexpected Results when Updating Pivot Table Data Source | Tableau Software
If you are not using one of these versions which version are you using?
Hope this helps!