total-function in script?

[#1]

Hi everybody,

I'm using the total-function in pivot tables, for example:

sum(Sales)/sum(total <District> Sales).

My question ist now, is there any possibility for the total-function for using in the script? I need to calculate a solution like this in the script.

Thanks

vicky

[rahulgupta]

Hey Hi,

Temp:

Load SalesPerson,

         District,

          Sales

From Table;

Left Join

Load District,

          Sum(Sales) as DistictSales

From Table

Group By District;

TempFinal:

Load Name,

        District,

       sum(Sales)/Sum(DistrictSales)

Resident Temp

Group By Name,District;

Hope this helps...

Regards    

[#3]

Thanks. It helps! I only hope before, that there is an easier way, but now I have my result

regards

vicky