I have a sheet containing sales with the name of the product and an amount for each sale. I’d like to display a list of products and the total value of sales for each product in a simple table.
I know that I could create a table in my spreadsheet and do the calculation there, using SUMIFs but I’d prefer not to because a) that’ll use up more rows b) I can get to the outcome that I want using a stack chart, where the legend gives me the table I want c) I’m applying date range filters to the data and it’s easier to do that with the individual transactions list.
Basically I’m looking for the same table that I get from the stack chart’s legend, without the chart bit. Is that possible?