Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    4

    Unanswered: How to do Ranking

    Hi,

    I create a sales report in Crystal v10 that contain the summary of different items within a Division. Now, how can I rank the divisions?

  2. #2
    Join Date
    Mar 2006
    Posts
    12
    more information, give details, even an example.

  3. #3
    Join Date
    Apr 2006
    Posts
    4
    I have different dimensions or items:
    -Division
    -Items
    -Sales
    -Budget
    -%Budget (this is the attainment or Sales/Budget)
    -Total Sales per Division
    -Total Budget per Division
    -Total %Budget per Division

    For example:

    Every Division have assign 3 items in wich I calculate their %Budget and in the summary of the Group of Division I calculate the Total Sales, Total Budget and Total %Budget. Division 1 have a Total %Budget of 98%, Division 2 have 102% and Division 3 have 100%.

    What I want is to add a formula that give me the ranking of the Divisions based on the Total %Budget. In other word the formula field should give me a#1 for Division 2, #2 for Division 3 and #3 for Division 1.

    Thanks for any hint you may provide.

    M

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •