3 Replies Latest reply on Jun 28, 2018 11:19 AM by Deepak Rai

    Top Absolute Values In Table

    crhoades

      Hey guys,

       

      In the image below I have the Sum of percent changes within each region within three states. I want this table to show only the top 2 absolute value percent changed region within each state. For example, in the table below, MISSOURI would show only  CCC) -.828 and DDD) -.078, OKLAHOMA would show only BB) .905 and CC) -.689, and TEXAS would show only D) -.858 and E) 1.261.

       

      Workbook is attached.

      Thanks