Adding up columns for sum

[nikhilg19]

Hi,

It is dynamic that today I may receive 4 columns; tomorrow I may receive 5 columns.

I want a new column which shows addition of these all coulmns

Is it possible to use formula something like (A1:A1)  ?

[danilang · Accepted solution]

Hi @nikhilg19 

In this case you want to add a record id, transpose your data, sum grouping by recordID and join back to the original data set

Workflow

Results for 4 columns

Results for 5 columns

Dan

[Thableaus]

Hi @nikhilg19 

Record ID, Transpose (Checking Dynamic and Unknown Fields) and Summarize Tool, then bring it back to your dataset using Cross-Tab and a Join Tool.

Cheers,

[Thableaus]

Right at the same time, @danilang!

Cheers,

[danilang]

Hi @Thableaus 

We seems to both be active around the same time.  Are you based in Europe?  I'm in Canada but I start early.

Dan

[Thableaus]

@danilang 

Cool! I'm in Brazil. I think it's a 2 hour difference from Toronto (not so sure what your time zone is in Canada).

Cheers,