Pivot table and unique values

[Stefan22]

My data base consists of numbers rounded to 2 decimals, but pivot table, for some reason, does not treat f.e. 1.23 and 1.23 as the same value.

Is there a way to get around this?

Thanks

 

[Aladin Akyurek]

My data base consists of numbers rounded to 2 decimals, but pivot table, for some reason, does not treat f.e. 1.23 and 1.23 as the same value.

Is there a way to get around this?

Thanks

Did you invoke ROUND for rounding?

 

[Stefan22]

Did you invoke ROUND for rounding?

hehe, it solved my problem.

Thank you very much!

 

[Aladin Akyurek]

hehe, it solved my problem.

Thank you very much!

You are welcome. Thanks for providing feedback.