SUM a series of Fields

[pablomind]

Hi everybody,

I have a tough a question. I have an excel table with a series of columns in sequence that match with the values of a field(Codigo_aplicable)...

So what I need is to find a way to sum every column(field) and match it with its proper match in Codigo_aplicable Field. An important detail is this has to be dynamic cause the number of columns(fields) will increase with time so I dont have a fix number.

So what I had been trying to do is this:

AGGR(SUM($(=Codigo_aplicable)),Codigo_control)

But this only works when I select a value in the Codigo_aplicable field. I need it to get its proper match in a Table Chart.

Any help?

Thanks,

Pablo

[marcus_sommer · Accepted solution]

I suggest to consider a transforming of your data-source before trying to calculate and to match their content in any way. To see what is meant take a look here: The-Crosstable-Load.

- Marcus

[pablomind]

Thank you very much!