Sum the amounts of a column in a filltered data

[nads_707]

I have a sheet with one column as product name and other column with particular amount. Each product can have one or multiple amount enteries. I have used slice to filter my data based on product name. I want to show the user the total amount (sum) of the selected product along with the individual enteries. Kindly suggest how to go about it.

[Craig_QREW]

If you have already filtered by product name in the slice then you should be able to just sum the price column of the slice in your table. 

SUM(product_name_slice[Price])

If I was doing this all myself then instead I would make a table for all the products listed only once use a foreign key in the pricing table and then create a virtual column where I would write an expression that looks something like this.

SUM(SELECT(table[price],[product_ID]=[_THISROW].[ID]))

This would populate with the total cost of the product by adding all the fields that have that product in them. 

I hope this is able to help, I will happily be of further assistance if you would like. 

Craig

QREW Technologies