2 Replies Latest reply on Feb 24, 2017 8:21 AM by Fábio Rocha

Rank of Sales / Sum of Sales of different date

Hi all,

I'm struggling with an issue I could use your help.

I need to create a dashboard where I have a list of top 10 Companies based on their Sales in 2016 sorted descending and a Rank on where those companies positioned in 2015.

So I would have a bar chart something like this:

A - 300K

B - 240K

C - 200K

D - 190K

E - 150K

V - 120K

W - 90K

X - 70K

Y - 65K

Z - 50K

And a Rank from 2015 that for the sake of demonstrating could be something like this:

A - #3

B - #1

C - #2

D - #9

E - #7

V - #14

W - #12

X - #28

Y - #5

Z - #8

I got the bar chart working but how can I build the second sheet, or a new field in the same sheet to represent the rank from a different year?

• 1. Re: Rank of Sales / Sum of Sales of different date

Hi Fabio,

Find my approach based on two different calculated fields and rank-functionality stored in attached workbook version 9.3 located in the original thread.

Step 1: Define calculated field Sales 2016

if [date]=#1-1-2016# then [value] END

Step 2: Define calculated field Sales 2017

if [date]=#1-1-2017# then [value] END

Step 3: Define Rank

rank(sum([Sales 2017]))

Step 4: Drag defined calculated fields to the right locations.

Regards,

Norbert

1 of 1 people found this helpful
• 2. Re: Rank of Sales / Sum of Sales of different date

Hi Norbert,

That is a nice approach, hadn't thought of that

Had to create another rank for 2016 so I could drop it to the left and filter the top 10 without filtering data for 2017 rank