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)
Tagged:
0