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.

13.1

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%.

13.2

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

13.3

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s