Wrong sorting in widget pivot table

How to
#1

Hello,

I have pivot table as widget.
pivot table

The problem is, as you can see, when I sort by avg(Plnění normy %) there are few rows which should not be there on top. I made sure that Plnění normy is type Number and is not empty in any record. Interesting fact is that it keeps happening only for rows where avg(Plnění normy %) < 100. That would indicate that it is working with it as type Text. Why is it happening when Plnění normy is Number?

Could it be that when I firstly created the table (database), I set Plnění normy accidentally as Text and after some time I set it to Number?

Thank you.

#2

Hi,

to help us identify the root cause, we would need to know the exact configuration of your pivot table.

Could you please send the details to support@tabidoo.cloud?
Include a description of the issue and, most importantly, how the pivot table is set up.

Thank you!