Looking for something?

You will find your answers here!

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    Comparing data from exported VT reports

    Products
    Sage Virtual Terminal
     
    Description
    Steps on how to create an Excel PivotTable for the purpose of filtering specific data from  
     
    Resolution
    In the example below, we picked a transaction report from the VT and compared duplicate transactions.

    Step 1: After you get the report from VT (include all the transactions you want to look for duplicates) click on cell A1 and do CTRL+T > OK



    Step 2:  Inset > Pivot Table > OK



    Step 3: Drag the Field you want to match (Message, Card or Acct, Name, etc.) down to the Rows and Value Boxes (same field in both boxes)




    Step 4: Right click in first cell under Total. Then click Sort> Largest to smallest



    If you have questions or require additional information, please submit a ticket and we will be in touch with you shortly.



    Was this article helpful?

    Still can't find
    what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Knowledge Base Software by