Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Question Unanswered: How to sort/order a stacked bar by Row Totals?

    I am creating a Cross-Tabs and a Stacked Bar Chart in Crystal Reports XI.

    The stacked bar chart is controlled by the cross-tab.

    I want to sort/order the stacked bar from highest to shortest based on top 10 Row Grand Totals.
    i.e. (or see the attachment)
    .......... Region1 Region2 Region3 Region4 Region5 . Column Grand Totals
    Product1: 1 0 0 0 1
    Product2: 1 0 1 0 1
    Product3: 3 0 0 1 0
    Product4: 4 0 0 1 0
    Product5: 1 0 1 0 3
    Product6: 2 1 0 0 1
    Product7: 2 0 0 0 1
    Row Grand Totals: 14 1 2 2 7

    How can I do to sort/order the stacked bar from highest to shortest based on top 10 Row Grand Totals?

    Thank you in advance.
    Attached Thumbnails Attached Thumbnails Capture.PNG  

Posting Permissions

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