Back end Variable

[abhaysingh]

i want to do some calculation at backend for this i need to use one variable.

sum(sales),

i m trying to make it by using let variable. but it is not showing me

let Variable= sum(sales);

i am using it like above..

can any one tell me how it will happen

[anbu1984]

Table:

Load sum(sales) as total_sales Inline [

Country,sales

IND,100

CHI,100

US,100 ];

Let variable = Peek('total_sales',0,'Table');

[amit_saini]

Try this:

LET vSales = '=sum(Sales)' ;

Thanks,

AS

[its_anandrjs]

Hi,

Write a variable like

SET vSumVar = 'Sum(Sales)';

and use this variable in any chart like $(vSumVar) for get sum value

But if want to do it with the load script

Table:

Load Regions,sales

Inline [

Regions,sales

R1,300

R2,600

R3,800 ];

SumTab:

LOAD sum(sales) as SalVal Resident Table;

Let vSumVal = Peek('SalVal',0,'SumTab');

And plot this variable in any text object or chart $(vSumVal)

Regards

Anand