Hello Andrew

Filtering charts would only work if you add both the chart and the table on the same page. You would be able to add a formula column which would calculate the sum of other columns (column1+column2+column3) and then plot that column on the chart.

I'm not sure if that's what you want to achieve, though.

I don't see a way you could do this, Andrew.

The charts look for data within cells, and each row is plotted on a chart as a separate data string. So, adding calculation functions to the chart is not possible.

You could, however, create a MySQL query-based table, where you would perform these calculations through the query, so the sum is in one row, in multiple columns. That way, you'd calculate the data from table1, in table2 and use table2 for displaying that data in a chart.

I never attempted to do this, but I suppose that it is possible.

You're welcome, Andrew.

Glad I could be of assistance (if I even was of any lol )

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.