5 Replies Latest reply on Apr 3, 2018 7:45 AM by Michael Hesser

    Filtering $ Amounts from Largest to Smallest within 2 Countries

    Chase Barker

      I am trying to figure out how I need to go about creating a filter that can apply to sorting $ amount from largest to smallest in each individual country and not only to the overall $ amount. Below in the picture Supplier A has the largest $ spend amount in the US but not in Canada. In Canada, Supplier B has the largest spend amount but does not in the US. Is there a way that I can apply this to only sort each individual country and not overall $ amount?

       

      Filter Question 4.3.18.PNG

       

      Thanks in advance!