1 Reply Latest reply on Mar 8, 2018 12:30 AM by saurabh.c.0

    How to reset Rank() after applying table calculation as Filter

    enkhbileg ganbat

      I have table similar to below. RankData1 and RankData2 is Rank() function of Data1,Data2 respectively.

         

      CustomerData1Data2RankData1RankData2
      A102654
      B344431
      C213243
      D451525
      E61816
      F93462

       

       

      I have been trying to reset RankData2 when Data is filtered by RankData1. Below is what i have. Is there way to reset RankData2

       

      CustomerData1Data2RankData1RankData2
      B344431
      D451525
      E61816