How to Use Pivot Table in Excel

How to Use Pivot Table in Excel

Release Date: 07/18/2024
Version: 8.6 & Up

In this video, we demonstrate a powerful feature in Excel called the "Pivot Table." While this subject is not directly related to Elliott Business Software, we do have a Report Desk feature that can export Elliott data to an Excel spreadsheet. Sometimes it is desirable to transform the Excel spreadsheet produced by Report Desk into a Pivot Table for better viewing.

Here is the YouTube Link: https://youtu.be/89ExPkUPbGk

We hope you find the presentation helpful. 



EMK/RSS

    • Related Articles

    • Converting Elliott Internal Date to Conventional Date Format in Excel

      Q - If I retrieve Elliott's data in Excel through ODBC, the date column is retrieved in an 8-digit numeric format like:20161231, where the first 4 digits are the years, the following 2 digits are the month, and the last two digits are the day of the ...

    • Avalara - Use Codes

      Release Date: 4/28/23 Updated: 1/23/24 Version: 8.6 and Above Use codes are used to determine why a customer is exempt from taxes. Use codes can be assigned at the customer type, customer, ship-to, and order levels. When determining the use code for ...

    • Btrieve Error 035 on XCOFORM D-Y-O-I Form Table File

      Release Date: 03/05/2019 Version: V7.x and up Q - I have created a new Picking Ticket form using DYO. When the users attempt to print a PT, they receive an error message: EL800P: Btrieve Error 035 on XCOFORM D-Y-O-I Form Table File See sample screen ...

    • AR0120 Accounts Receivable State Table File Maintenance

      State Table File Maintenance Application Overview The purpose of this program is ensure correct state abbreviations for address and shipping accuracy. For example, is Alaska AL or AK? Is Montana MO or MT? Run Instructions The system comes with a ...

    • Btrieve Error USE on COP Lock File

      Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...