Using Aggr Function

[jhona1737]

Hello All,

I am trying to get a porcentage by week as shows on the attachement, but I am getting the total porcentage for the month I think I can use Aggr function. This is the scrip I am using

sum({<[Stock transaction type]={'11'},Source country]={'CL'},[Item type]={'320'}>}[Catch weight])/

sum(TOTAL{<[Stock transaction type]={'11'},[Source country]={'CL'},[Item type]={'320'}>}[Catch weight])

Thank you All 

[raman_rastogi · Accepted solution]

try this

sum({<[Stock transaction type]={'11'},Source country]={'CL'},[Item type]={'320'}>}[Catch weight])/

sum(TOTAL< Week>{<[Stock transaction type]={'11'},[Source country]={'CL'},[Item type]={'320'}>}[Catch weight])

[jhona1737]

Perfect it works!! thank you!