Showing some values based on SUM, other values based on the most recent date available for the week?
https://us.v-cdn.net/6032830/uploads/PTYF8ZXJ1WBI/data-sample.xlsx I am working with a dataset that pulls in sales and inventory data for items on a daily basis. In data analyzer, I created a table with the data grouped by week. After grouping by week, most of the fields in my card (i.e. Revenue, Units Sold, etc.) are…
