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

    Rank of Sales / Sum of Sales of different date

    Fábio Rocha

      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?

       

      Thanks in advance!