Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Perfect it works!! thank you!