Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=SUM({<R3={'C'},[Sold To Opt Out Flag]={'N'}>}TOTAL <[Territory Name]> [Monthly Sales]
Load [Territory Name],SUM([Monthly Sales])
Resident Table
Where R3='C' and [Sold To Opt Out Flag]='N'
Group by [Territory Name]
if(R3='C' and [Sold To Opt Out Flag]='N',Aggr(sum([Monthly Sales]),[Territory Name]))
Is it working in script editor
Load [Territory Name],SUM([Monthly Sales])
Resident Table
Where R3='C' and [Sold To Opt Out Flag]='N'
Group by [Territory Name]
if you want the sum then you need to create a resident load and use the group by function
Thanks for your reply
But the actual expression is
=AGGR(NUM(RANK(SUM({<R6={'C'},[Organization Name]=,[Organization ID]=,[Organization Name|ID]=,[Sold To Opt Out Flag]={'N'}>}[Monthly Sales]), 4, 1)),[Organization Name|ID])
the above is the script i am trying to do in script editor
Hi,
set analysis wont work in the script . Please follow the anbu approach
hi ,how to use rank function in load statement
Temp:
Load [Territory Name],SUM([Monthly Sales]) MonthlySales
Resident Table
Where R3='C' and [Sold To Opt Out Flag]='N'
Group by [Territory Name]
Rank:
Load *,RowNo() As Rank Resident Temp Order by MonthlySales desc
thanks for reply anbu will apply n let u know