Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you very much!