Need Help. I have a bar graph that is giving me 10 years worth of contributions but on the graph I only want to show the last 5 years. Along with the contributions made prior to the 5 years
I have tried the top N but this gives me the top 5 years of contributions which may not be within the last 5 years and it also does not order them by Year End Date in ascending order.
I have tried writing a formula to give me just the last 5 years but this does not include the total contribution just what happened in the last 5 years.
I have also created a subreport passed the data for the first 5 years to the subreport as either a shared var of a parameter then tried to add this number to the contributions for the last 5 years with should work. But then I can't graph on this number.
Thanks in advance for your help.