SUMS ON SCRIPT

[#1]

I have a question, Can i do some sum on the script instead on the Set Analysis?, example i have a pivot table chart and i need to do a lot of sum with the info in the chart, it is possible to do it on the script to let less charge on the chart???

Regards

Carlos

[rwunderlich · Accepted solution]

You can create new summed fields in the script and use the GROUP by clause to specify at what group you want to sum. Something like:

LOAD Month, sum(Sales) as "Monthly Sales"
RESIDENT Sales
GROUP BY Month
;

-Rob