Hi Boban,
>I have a table used in report with two fields SOMEDATE and SOMENUMBER.
>
>I have made group by SOMEDATE in report.
>
>I want in group footer to show total SUM of SOMENUMBER for dates before date that is current in group.
>
>How to do that? (preferably it would be variable)
If I didn't mistake. I think that these steps can help you:
- Create a new variable and in Value to Store put SOMENUMBER.
- Set Calculate to "Sum" and Reset At to "End of Report"
- Put a Field in Group Footer and put your variable's name.
Note: This can to be done directly in Field.
Good luck!
Erick
Força Sempre!
Strength Always!