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

    Top Absolute Values In Table


      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.