Script help

[ankit777]

Hi All,

Suppose I have a table like below.

Id, Marks

1,10

2,34

3,21

4,56

5,11

I want to draw a chart in which dimension will be id and expression will be sum(Marks)

I want to overide the id , show same values of sum corresponding to all Id. ie, in chart it should show 132 corresponding to all id's.

Please help how the expression needs to be changed.

[MK_QSL · Accepted solution]

Expression

SUM(TOTAL Marks)

Or

You can get the same by script

Table1:

Load * Inline

[

  Id, Marks

  1,10

  2,34

  3,21

  4,56

  5,11

];

Left Join

Load SUM(Marks) as TotalMarks Resident Table1;

[ankit777]

Thanks Manish