Hello itay

Thank you for your interest in our plugin, and I apologize for the late response.

If your users need to log into WordPress first, I believe the first point may be easy to do.

When users register/log-into WP, they get a unique User ID, which is stored in the database, in wp_users table. wpDataTables can use that to display only the rows which contain their user ID, so each user can only see and edit only their own data. To have the table show only their username, instead of an actual user ID, you would need to have a separate table which would have the user information, and each row would be associated to a separate user. Then, you can use the User ID column in the first table, and connect it to the other table via Foreign Keys, so the plugin displays their user name instead of User ID. If you have all that info in an Excel file, you can use it to display the data from there by linking to that Excel file. That table will not be editable though, as it is only used to display information from an existing data source.

2. If you wish to simply add a SUM option at the end of a column, you just need to go to the column's settings, and turn the SUM option on. You can take a look at our calculation functions to see how it actually works.

Best regards.