we are trying to do a running total in a table. For example:
Field 1: name with data rows of EXAMPLE, EXAMPLE 1, EXAMPLE 2, EXAMPLE 3, EXAMPLE 4
Field 2: amount with data rows of 1, 5, 10, 15, 20
Want to have a table like this:
EXAMPLE 1 5
EXAMPLE 2 10
where first amount row is the amount from the EXAMPLE data row and the second row under amount is the running total. I’ve tried groupings and sub groupings, several different user variables, etc. and can not figure this out. Do you have any suggestions? Thank you.