I think this is simple but I cannot figure it out. I have a running total that I only want the last record to display. How can suppress an unknown amount of records before the last record is displayed?
Thanks campsys, this did work for my absolute last record. I have my running total resetting at the group level (failed to mention that earlier) so how can I use this not onlastrecord function when grouping?
For example, I have a count of employees grouped by region, I only want to see the last value of the running total for region A. The count then resets and now I want to see the last value for region B.
North Region:
employee (in my running total I see) 1
employee 2
employee 3
Thanks you guys soooo much! I got it to work. I put a cross tab in the group header that totalled the "employee" count by region- suppressed fields as needed. It displayed a line item total of the count of employees. Then I did a standard running total in the group footer ( moved everything to group footer thanks to Campsys, dont know why I did not do that in the first place, but maybe I did and got frustrated.) Anyway, I just compared counts of the two fields and when they were equal I did not suppress ( got that idea from Lbass).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.