Question Re: Displaying Revenue from Top 20 Customers in Button

[#1]

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

[#2]

Sorry, that should read top 10 customers