RunningSum Property Example — Sales Report
The following example shows a sales report with two group levels — Month and Type of Food. Each text box in the Type of Food group footer (January Chocolates, January Meat, and so on) contains the following expression:
=Sum([Sales])The RunningSum property of each text box is set to one of the three different values: No, Over Group, and Over All.
| Group levels | No | Over Group | Over All | |
|---|---|---|---|---|
| Month: January | ||||
| Type of Food: Chocolates | ||||
| 02-Jan | 25 | |||
| 22-Jan | 75 | |||
| January Chocolates | 100 | Jan Food 100 |
YTD Sales 100 |
|
| Type of Food: Meat | ||||
| 03-Jan | 90 | |||
| 20-Jan | 60 | |||
| January Meat | 150 | Jan Food 250 |
YTD Sales 250 |
|
| Month: February | ||||
| Type of Food: Chocolates | ||||
| 05-Feb | 70 | |||
| 19-Feb | 80 | |||
| February Chocolates | 150 | Feb Food 150 |
YTD Sales 400 |
|
| Type of Food: Meat | ||||
| 12-Feb | 150 | |||
| 22-Feb | 100 | |||
| February Meat | 250 | Feb Food 400 |
YTD Sales 650 |
|