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
How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019
Release Date: 06/30/2020 Version: 7.x & Up Elliott's data is based on the PSQL database engine. In Excel, you can access the PSQL database through an ODBC interface with the Microsoft "Query" function. The following procedure outlines how you can do ...
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 ...
Microsoft Query Is Missing on Excel After Office 365 Update
Release Date: 06/07/2024 Version: N/A Q: We use Microsoft Query extensively to retrieve data from Elliott database. After the last update for Office 365, my Microsoft Query is missing on Excel. How can I recover this feature? A: The solution is to go ...
Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field
Release Date - 1/4/18 When exporting Elliott's item numbers to CSV through Elliott-provided reports with a CSV export option, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item ...
What Is the *.^01 File for My PSQL Btrieve Table?
Q - I see in my data folder, for my NOTE table, the corresponding data file is NOTE.BTR. But I also see another file NOTE.^01. See sample screen below. What is that file? Do I need to back up the NOTE.^01 file? A - The PSQL engine can create a ...