Need Expression

[saumyashah90]

I Have

Load * Inline [

A,B,C,D

1,2,3,4

5,6,7,8

9,10,11,12

6,4,3,2

];

i Want Output as

                       A   B   C    D
Sum               21  22  23  26

Count              4     4    4    4

[saumyashah90]

any one?

[tresesco]

PFA.

Easier way should be there, you might have to transform the table in the script.

Update: the Saumya_tes one is more dynamic !

[senpradip007]

Do you want the output in script or in UI ?

[saumyashah90]

Hey tresesco

That was nice but still,

For now i have only A,B,C,D in real i have 1000's of fields
i want it kind of dynamic.

[saumyashah90]

any where in UI or Script,

Please consider that i have 1000's of similar fields like A,B,C,D

[tresesco · Accepted solution]

Check my second attachment please.

[senpradip007]

PFA

[saumyashah90]

Hi Tresesco,

That was correct. Can you explain the use of

CrossTable
Load '1' as Dummy,*;

//What does this do?

Load * Inline [

];

[tresesco]

it transform the table. A, B, C, ... values are taken into a field and the corresponding values in another field. 'Dummy' field is created and dropped for the proper formatting of table(by default crosstable() takes the first field as it is, and i needed to change the first field). Hope this gives you an idea. for better understanding learn CROSSTABLE a very useful function.