You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DM When opening Pivot table values are multiplied. They are correct after refreshing pivot. Why?

Summary:

Thanks in advance.

Why when opening a demand plan pivot table items of a particular product hierarchy group (business area) are incorrect. They seemed to be multiplied by 9.

  • 4/4/26 = 40,000 X 9 = 360,000
  • 5/9/26 = 20,000 X 9 = 180,000

Then after clicking the pivot's table refresh icon button the value change back to the correct values.

  • 4/4/26 = 40,000
  • 5/9/26 = 20,000

Why is this happening?

NOTES:

  • We recreated the table by copying a seeded pivot table and configuring with the same configuration as the pivot table facing this issue. And that new table is facing the same issue as well. No hidden dimensions.
  • This is not happening to items from another hierarchy group (business area)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!