Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently trying to use a button to show the total Profitability from the Top 20 Customers. I have the current statement, however it is not working. I'm wondering if anyone would have a suggestion.
=sum({<[Customer Name] = {'=Rank(sum(Amount*-1))<=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'019'} >}Amount) * -1 - sum({<[Customer Name] = {'=Rank(sum(Amount*-1))<=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'020', '021'} >}Amount)
Kind Regards,
Antoinette
Sorry, that should read top 10 customers