Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Table:
Load sum(sales) as total_sales Inline [
Country,sales
IND,100
CHI,100
US,100 ];
Let variable = Peek('total_sales',0,'Table');
Try this:
LET vSales = '=sum(Sales)' ;
Thanks,
AS
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