Highlight top 40%

In this scenario we have Lines, Categories and Revenue objects from the eFashion database and we want to highlight top 40% (based on revenue) of Categories.


First we need to count how many Categories we have in each Line and calculate what 40% of that value is:

=COUNT([Category]) IN SECTION *0.4

Next we calculate a rank of Categories based on Revenue.

=RANK([Sales revenue])

And finally compare these 2 numbers in an alerter. Notice that we also highlight bottom 40%.


Here is the full table with all calculations and final results.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s