1 Reply Latest reply on Jan 28, 2014 7:30 AM by David Kim

    Sorting by measure of an attribute

    David Kim

      Hi everyone,

       

      Looking for some help here as I am stumped!

       

      I have a list of suppliers as my rows and a dimension with two attribute values. In the crosstab I have the count of audits by each supplier, split by basically a pass/fail.

       

      I am attempting to sort the suppliers in descending order by the number of failed audits, but when I go to the sort option supplier I can only sort by the count of audits as a whole, not by the specific attribute.  This results in suppliers being sorted by total number of audits, but in my case this doesn't help as I am attempting to sort by worst offenders top to bottom.

       

      Does anyone have a solution to this?  Please see the screenshots and I'll post a workbook if needed.

        • 1. Re: Sorting by measure of an attribute
          David Kim

          Solved it myself after having my morning coffee!

           

          I created a calculated field by using the attribute value, and gave failed audits a value of 1 and passed audits a 0:

           

          CASE [VENDOR_ERROR] WHEN 'VENDOR ERROR' THEN 1 ELSE 0 END

           

          I then added the field as a detail, allowing me to use it as a sorting field