I need to create an AVG based on the cell data in row_group1 and the number of months that have data. I have the sum of row_group1, but cannot get a count on number of months, and just entering an AVG function in the total column does not produce the correct results.
I have two row groups, and a single column group on "Month" that produces row data by "monthname".
I can get the SUM of my CountDistinct(Fields!CustID.Value), so if I can get the count of the number of "Months" produced by my column group I could calculate my own average, but I cannot get the correct count of months using InScope, (returns all 0's):
Basic structure of matrix:
Service Feb Mar Apr AVG # of Distinct Customers per Month
Cleaning 3 7 2 4