Multiple row and multiple field summing in a new field

[julius]

Hi everyone,

I have many records and many fields, I want to sum every record from every field like this:

thanks!

week	field 1	field2	field3	……..	field 1020
1	1	0	1		1
2	0	1	1		1
3	1	1	1		1
4	1	1	1		1
5	1	0	0		1
6	1	0	0		0
7	1	0	0		0
8	1	0	0		0
9	0	1	0		1
week	new_field
1	3
2	3
3	4
4	4
5	2
6	1
7	1
8	1
9	2

[AndréB · Accepted solution]

Hi @julius - seems like a job for the transpose and summarize tools.

[MarqueeCrew · Accepted solution]

@julius, 

Here's my take:

1. TRANSPOSE:
   1. KEY = WEEK
   2. Data = All other fields, including "unknown"
2. SUMMARIZE
   1. Group by Week
   2. SUM Value (note:  you might need to change type to a number using a select before this)
3. That's it.

[julius]

thank you!