Beast Mode: How to calculate Fixed Average dependent on a different Fixed Sum
Hello! I have a dataset with the following fields: Day, Company, Spend, and Revenue. I want to find the Average Revenue per Company for a selected time period, but only include Companies that have cumulative Spend greater than zero (for the selected time period). I have attached a photo of my sample data. Basically, I want…
