Accumulating values

Wed, 03 Jul 2013 19:06:09 GMT

I have this values for 5 offices in a month, the values are by day (1..31):

When I select any day (1..31), I need to show a table with 2 columns:

A. The values of the day selected.

B. The values accumulated between the day 1 through the day selected.

Examples:

Select day 1

Select day 9

Select day 23

Thanks.

Re: Accumulating values

Gysbert_Wassenaar — Wed, 03 Jul 2013 19:16:12 GMT

Try these two expressions:

1: sum(Value)

Acum: sum({<Day={'<=$(=only(Day))'}>} Value)

Replace Value and Day with the actual names of your fields.