Hi All,
I am looking for a Normal Distribution chart (Bell Chart), preferably I want to see the year on year normal distributions. If some one has one please let me know. Alternatively please can you have a look at my aggr problem using set analysis. It has made me somewhat AGGR [:@]
I have a solution for a single selection and can get the graph if I set the reference, however have struggled to get it working for a second or third year using set analysis. The problem is in my aggr function
avg(aggr(sum({$<Year = {$(=max(Year)-1)}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>}
Donation.ber_amountgross*(DonationFundAllocation.ber_percentage/100)),
count(Donation.ber_donationid)))
this is the fumula that works for the present year
avg(aggr(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>}
Donation.ber_amountgross*(DonationFundAllocation.ber_percentage/100)),
Donation.ber_donationid))
I know the problem is aggr part and not sure what to do with DonationFundAllocation.ber_donationid I have tried using count.
Hope some one can help,
Neil