Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Order Stacket Bar Chart by Summed Field

  • 1.  Order Stacket Bar Chart by Summed Field

    Posted 19 days ago
    Edited by Jose Gregorio Diaz Vasquez 19 days ago
      |   view attached
    Hi All,

    I have built this chart in dynamics:

    But the problem is that the "Sum(GrossWt) is being ordered in the bar by Agent (alphabetical way) and I  would like to do it by GrossWt, see the example below in excel


    Is there any way that I can do this, I am using XrmToolBox with Advance Chart Editor to customize below you have the Chart Code in the attachment.

    Thank you in advance,

    Jose G Diaz

    ------------------------------
    Jose Gregorio Diaz Vasquez
    Lane Technology Solutions
    Winter Park FL
    ------------------------------

    Attachment(s)



  • 2.  RE: Order Stacket Bar Chart by Summed Field

    Posted 18 days ago
    Hello Jose,

    With weight being your aggregate I don't think that is something that can be sorted on. I believe the sort order only applies to your groupings which in your case are date and agent. @Ulrik Carlsson might be able to shed more light on this or correct me if I am wrong.​

    ------------------------------
    Scott Florance
    Business Applications Consultant
    KTL Solutions, Inc, Frederick MD
    ------------------------------



  • 3.  RE: Order Stacket Bar Chart by Summed Field

    Posted 18 days ago
    Thank you Scott,

    Let see if we can get an answer from @Ulrik Carlsson   :)

    ------------------------------
    Jose Gregorio Diaz Vasquez
    Lane Technology Solutions
    Winter Park FL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role