Sum Column Not Reflecting Filtered Data in AppSheet

[rahu]

I am facing an issue with a table in my AppSheet application. I have a column called “Weight” and another column that calculates the sum of the “Weight” values for all the rows. However, the sum is being calculated for all the rows regardless of any filters applied. I need the sum to be calculated only for the filtered data.

Below is the screenshot of the query I have used and the table:

Can anyone help me with a solution to calculate the sum of the “Weight” column based on the filtered data?

Thanks in advance!

[Joseph_Seddik]

Where are your “filtered data”? How do you filter them?

[rahu]

I am using default filters

[Joseph_Seddik]

This is a visual filter only and does not result in changing column values.

If you need to visualize aggregate sums, averages, etc. based on filtered displayed entries, I recommend you to use Google Looker Studio having your app as source, instead of the app’s views.