Forum Discussion
AYDIN_KAYI
Jan 29, 2020Copper Contributor
Pivot Table Data Formati Problem
Hi, I have serious problem. Eventhough all the datas are same and there is no empty. when i used pivot table same datas classified differently. I couldnt solve the problem could you please let ...
PReagan
Jan 29, 2020Bronze Contributor
Hello AYDIN_KAYI,
There are slight differences in some of the product names that makes it so that they "appear twice" in your pivot table. Values with differences like:
BC-BAZ SIYAH and BC-BAZ SİYAH
BC-BMW 354 TITANIUM GUMUSU and BC-BMW 354 TITANYUM GUMUSU
BC-FI 483 MENEKSE MAVISI and BC-FI 483(MENEKSE MAVISI)
Fixing these mistakes would get rid of your issue in the pivot table.
Edit: Patrick2788 beat me to it!