Thanks for this mate! I just have one question based on your excel data - How would you answer which Month Year had the most sales in Looker Studio (i.e., after aggregating by product) and to take it one more layer, which product contributed to that month year with max sales? I have not been able to figure out how to get max value after sum aggregation.
@siavashkanani So would a field using data from a Google Sheet ever apply an AUTO aggregation?
Not automatically, but if you create a data source level custom field with a formula like SUM(this)/SUM(that) the result will become AUTO aggregated.
Thanks for this mate! I just have one question based on your excel data - How would you answer which Month Year had the most sales in Looker Studio (i.e., after aggregating by product) and to take it one more layer, which product contributed to that month year with max sales? I have not been able to figure out how to get max value after sum aggregation.
when not to use the auto aggregation? nice video man!
Thanks!