If I understand correctly, there is a need to utilize the dashboard actions but to not have them manipulate the data in a way that will disrupt calculations being calculated on the table. Now, there is no way to lock these from happening. What I would suggest is building a dashboard that has your totals and other stable(there exists a need to not have these changed) calculations into one worksheet and then add that to a dashboard. Then using an additional worksheet that could be manipulated by the end user, that would change the data on another section of the dashboard.
Here is another response I had written that might include some additional helpful information in regards to the above stated issue.
As well if you could provide a sample packaged workbook I could examine your situation more closely:
A sample packaged workbook (.twbx). If the data is confidential, a sample packaged workbook with sample data that mimics the structure of the original workbook is sufficient. Instructions for creating and sending a packaged workbook can be found at the following link: