Is there a way to create dynamic averages based on the dimension that I use?
Category 2#: Size
Category 3: Color
The data has a number of rows for each date (essentially a row is a sales transaction)
How can I create an average formula that will compute daily average (by whatever period that is filtered) that will update as I move dimensions. It seems strange that I have to create a calculation for each "level".