Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks. It helps! I only hope before, that there is an easier way, but now I have my result
regards
vicky