Sum of column in embedded table that has been filtered

1

Hi,

I created an input variable that sorts an embedded table by Shipper # field. I’d also like to add/display the sum of the column called Gross, based on the results from the Shipper # variable sort.

image
image1754×970 126 KB

  1. Is this possible?
  2. If yes, what option(s) are available for this?

Thanks.

2

You can add a query and aggregation to that table (on the table page) and apply the same variable to that query filter.

3

I was able to have my query = app input. I went into the app editor and changed the app input value to the variable I was trying to sort by. This worked very well.

Thanks!!