I have a general question on tables and total rows. I noticed that there does not seem to be a way to do totals on just the data in the actual table. So let's say you filtered the data in the table to only include certain values, and you want to do a total sum of the filtered values...
When you ask for a total it gives the dataset total, not the total in the table currently being viewed. As you can see from the photo attached, the total row gives a ridiculously large total compared with the data presented. It would be extremely helpful to be able to do totals and percentage on the table itself.
Meaning that when in a table view, the values could be stored locally and one could do total and other equations off the table values rather than the dataset behind the values. Is that something currently being worked on? Is there a way to perform this function already that I am not aware of?