5 Replies Latest reply: Sep 14, 2012 11:56 AM by Stefan Wühl RSS

    display rank in text object

    Chris Hopkins

      Hi,

      I have the following data for week 5..

      Table1:

      Company           Site         Sales     

      Company 1       Site 1         1000

      Company 1       Site  2        1800

      Company 1       Site 3         1250

      Company 1       Site 4         2500

      Company 2       Site 1         1700

      Company 2       Site  2        2000

      Company 2       Site 3         4250

      Company 2       Site 4         1500

      Company 3       Site 1         4000

      Company 3       Site  2        9800

      Company 3       Site 3         1450

      Company 3       Site 4         2800

       

      Table 2

      Company          Avg Sales        Rank

      Company 1         1637               3

      Company 2         2362               2

      Company 3        4512                1

       

       

      Each Company has its own tab within the application. We want to display the rank of 'Customer 1' in a text box (Obviously the rank will be based on a week).

       

      e.g.

       

      Week 5 is selected.

       

      The text box will display Customer 1's rank (3)

       

      We also want to display the Site rank too.

      So for example,

      In week 5, the best site for customer 1 is site 4 which ranks no.5

       

      Can anyone help please?