I have a report that I created in XI. The report is based off of several tables(Completed Activities, Contact Info and Sales data by Month).
The report is based on the completed activity date. What is being displayed is the YTD sales, trailing 12 month totals (from the prior month of the completed activity), Subsequent Sales (any sales after the activity happened), Run Rate((The subsequent sales/date difference from the max date range of the date parameter and the activity date)/(trailing 12 months/12)*100). I have the following grouping, G1 is the completed user and G2 is the contact.
All the above fields are being displayed on the G2 level. This part works fine.
The problem I am having is that I need to now add run rate by G1. I created a reset formula and put it in the GH1 and put the display in the GF1, but what ends up happening is that the reset is happening per page and not on change of G1.
When I remove the reset value it creates the value without a reset on every page.
Any help would be helpful.
Thanks
Edited by MAUser - 14 Apr 2011 at 2:56am