7 Replies Latest reply on Feb 20, 2017 12:48 PM by Tom W

    Calculation logic for duplicates

    Jilani Shaik

      Hi i have a text chart like this

      if same request id repeated in multiple regions i want to calculate the highest region

      suppose request id=102 repeated in east,west,north then i want to display north record only

                      request id=103 repeated in east,west,north,south then i want to display south record only

      and the request id=100 is duplicated i want only one time

       

      the output will be following

       

      report is in text chart

       

      plz help me asap