Drill Through skipping one dimension when Drilling

Summary:

Hello,

I created a drill through in both the development and production environments. The drill through works well in the dev environment, and the sum of the data ties back to the expected total, however in production, one dimension is omitted, and some rows are skipped during drill through, thus the total amount in the drill through does not tie back to the total.

Both environments point to the same source, and the integrations/application/target/Import Format are laid out exactly the same in both environments.

What am I missing?

Content (please ensure you mask any confidential information):