Add a Value of % of Total to the Summary Total Options (SUM, MAX, MIN, AVERAGE, etc.)

[ATTACH=JSON]{“data-align”:“none”,“data-size”:“large”,“data-attachmentid”:86633}[/ATTACH]

When you put together a summary report pivot table with the last column being a Total (SUM) column, it would be nice to be able to have a % of Total column as well. I have not been able to achieve this with Scriptcase however it’s easily created in Excel with a simple formula. If you create a summary table and enable charts, specifically a PIE chart, the totals are converted to this value of % of Total anyway. So the calculation appears to be part of the charts application. Why not make it an option in Grid/Summary applications as well?

percentage-of-total.png