2 Replies Latest reply: Aug 1, 2011 9:47 AM by vicky_qlik RSS

total-function in script?

vicky_qlik

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

  • Re: total-function in script?
    Rahul Gupta

    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