Unfortunately, calculating SUM, MIN or MAX from a calculated column is not supported by our plugin, as You have already noticed. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
However, there is a workaround for this issue if You were to create a MySQL query table. To do this please prepare a MySQL view (a stored query), which will return the data that you need (You'd have to create a view in Your database editor (e.g. phpmyadmin)), call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
I discovered that it is not possible to add the total sum of a calculated column. Any update on when this function will be available?
It is a critical number in the whole setup of my table and the purchase of your product
Best Regards
Wim Broens
Hello Wim.
Thank You for Your purchase.
Unfortunately, calculating SUM, MIN or MAX from a calculated column is not supported by our plugin, as You have already noticed. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
However, there is a workaround for this issue if You were to create a MySQL query table. To do this please prepare a MySQL view (a stored query), which will return the data that you need (You'd have to create a view in Your database editor (e.g. phpmyadmin)), call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables