Multiple row and multiple field summing in a new field

Question

Hi everyone,

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

thanks!

weekfield 1field2field3……..field 10201101 12011 13111 14111 15100 16100 07100 08100 09010 1            weeknew_field   13    23    34    44    52    61    71    81    9

2

AndréB · Accepted Answer

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

MarqueeCrew · Accepted Answer

@julius,

Here's my take:

* TRANSPOSE:* KEY = WEEK
* Data = All other fields, including "unknown"

* SUMMARIZE* Group by Week
* SUM Value (note:  you might need to change type to a number using a select before this)

* That's it.