Accumulating values

[#1]

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

Day -->	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
Office 1	44	7	13	47	30	34	10	15	5	28	31	19	14	28	1	46	9	24	1	14	32	31	15	34	27	35	2	50	2	13	24
Office 2	25	34	42	40	9	8	16	12	12	16	21	33	27	21	12	5	13	40	15	47	15	21	35	7	41	19	27	11	27	46	37
Office 3	41	30	20	3	9	40	9	18	17	11	24	38	24	24	25	30	31	21	26	32	3	27	6	28	5	1	20	40	42	11	32
Office 4	22	33	46	41	35	17	47	19	34	43	16	25	27	30	39	6	11	17	29	15	16	37	13	24	0	11	50	32	23	23	36
Office 5	14	31	2	22	33	48	49	43	8	43	16	43	42	23	6	26	6	49	24	41	22	34	22	50	28	19	39	18	35	30	19

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
1 Acum Office 1 44 44 Office 2 25 25 Office 3 41 41 Office 4 22 22 Office 5 14 14	9 Acum Office 1 5 205 Office 2 12 198 Office 3 17 187 Office 4 34 294 Office 5 8 250	23 Acum Office 1 15 498 Office 2 35 519 Office 3 6 509 Office 4 13 618 Office 5 22 647

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Try these two expressions:

1: sum(Value)

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

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