none
sorting in matrix

    Question

  • hi

    i need to do sorting inmy matrix

    i am getting values like this

    cI        CII              CII             total                CIV

    i want this to order ,how to do that,

    all are coming from 1 field

    Tuesday, April 30, 2013 2:05 PM

Answers

  • Hi Tsql,

    In the last of your expression missing a condition for value 8. You can change it to:
    = switch(Fields!Deschedule.Value ="CI",1,Fields!Deschedule.Value ="CII",2,Fields!Deschedule.Value = "CIII",3,Fields!Deschedule.Value = "CIV",4,
    Fields!Deschedule.Value ="CV",5,Fields!Deschedule.Value = "R",6,Fields!Deschedule.Value="UNK",7,Fields!Deschedule.Value = "something",8)

    Hopes this helps,

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, May 01, 2013 8:36 AM

All replies