Let's skip float as it is only inches from being blown to bits anyway.

I never included float in the first place as it is difficult to group data on a float value. I never could think of a usecase with a float as ID value.

Do you want the decimal as data cell value or ID value?

If you want to use decimal as ID value, could you describe a usecase for that? Or even better, create a little demo project and invite me to it. My email riddle: first.last and I work for itvisors dot com.

Edit: Decimal seems to work just fine. Can you give it a try and help me test this?

If all is well, I will recreate the release and try to get it in the appstore.

https://github.com/synobsys/mendix-PivotTableWidget/blob/master/test/widgets/PivotDataWidget.mpk

Edit2: I ran into issues with another widget during sandbox deploy. It seems the deploy does not like that I refer to the JavaScript Big library (for Decimal support) by including big/big in the module list. Locally this works perfectly but the deployment and the check widgets tool choke on my widget, build log has an error about referring to big/big

Edit 3: I convert Decimal to JavaScript Number before using in the calculations. No more big/big reference so no more deployment issue. But only second best because I wanted to use Big objects throughout the pivot table widget for accuracy. Please give it a try!