This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve been having the same issues with lookup fields and pivot tables. The short term hack is making a formula field that uses the lookup table value and then using the formula field in your pivot table. Otherwise this is a bug that needs to be fixed.