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.
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
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |