I'm stuck. I'm trying to get the LINEST_R2 function to work and I can when I'm using two data points (x and y). But when I want x to be the sum of two points, I'm stuck.
This works: LINEST_R2 (Sales0500.1, Overhead0700.1)
But instead of Sales0500.1, I want to use Sales0500.1 + Sales0500.2 + Sales0500.3.
I tried putting in is as a sum, but it yelled at me for nested aggregation.
I tried making it into a variable, and it accepted it, but didn't give me any results.
