Quick Pivot in Alchemex

I would like to create a Pivot to neaten my data but do not know Excel too well. Is there an easy way within Alchemex to create a Pivot?

Yes, you can use an Alchemex add-in to quickly create a Pivot.

Method

1. Run your report, in Excel select the Add-ins tab on the Ribbon, and in the Report Tools group select Quick Pivot.





2. The Quick Pivot Wizard will open, make your selections, it will automatically select sheet1 as Source Sheet.





3. Select the Format tab for any changes





4. Selecting any of the 3 color boxes in the Format window will open the Color window:





5. Make any necessary changes and click OK.
   
   Click OK and Close
   
   You now have a quick Pivot with only a few clicks:






Click here to download this latest tip in pdf format

How to hide the raw data of a report.

I would like to hide the source or raw data in my final report. Is this possible?

Yes, you can hide the first sheet containing your raw data..

Method

1. In Report Manager, select your report.



2. In the Properties window, click Show Advanced.



3. Click Hide the Source Data in Report and click Apply.





4. When running your report, Sheet1 containing the raw data will be hidden.





5. Normal Excel functionality can be used to unhide the sheet.


(Right-click any sheet and select Unhide)





Click here to download this latest tip in pdf format

• Parameters
• Adding a Lookup to a Pass Through Variable
• Renaming a Data Expression
• Consolidations
• How to Link an Excel 2007 template to a Report
• Adding a company name to an account number
• Using the Alchemex Administrator to Sample Specific Data
• You created a collection of reports that are running on a specific database you would like to test the reports on different databases.
• Selecting multiple columns
• Copying or moving Union reports
• Cancelling a Report
• Comparison Methods
• Running a report in Design Mode
• Where to start when creating a first report
• Delaying Recalculation
• Adding my own defined System Variables
• Activate Reports
• Change Metadata Repository
• History of the report
• System Variables
• Add Dataless Report
• Apply the aggregate filter to multiple columns
• Unlock MS Excel
• Distribute an Alchemex report automatically
• Automatically distribute Alchemex reports on the web or an intranet
• Creating and Linking excel reports
• Interrogate data directly with the Drill Down tool
• Drill down on Income Statement and Balance Sheet figures
• Import and export reports
• Automatically running macros
• Scheduling a Report
• Use of aggregate Function
• Creating Excel Formulae in your report
• Viewing the raw data before it is passed through to Excel
• Create a run time version of a report and run it from your desktop
• Hiding and Showing Reports
• Create a backup in Alchemex
• Alchemex add-ins missing from the toolbar in Excel
• To relocate or remove a workstation license
• Renaming a data expression
• Running a batch report
• An overview of the Report Creation Process
• How to protect the Output Book
• Customise the look and layout of the Alchemex reports
• Quick Navigating between Report Manager and Administrator
• Viewing the SQL code passed by Alchemex to the ODBC Driver for a report
• Copying and Pasting Reports
• Hide zero rows
• View Data Container from Report Manager
• What is an Alchemex Add-In Module?
• Serialisation
• Renaming or moving a Connection
• Locking and Unlocking a report
• Using an Excel Workbook as a data source
• Updating Alchemex through a proxy
• Compact Metadata functionality
• Using Find and Replace in Alchemex
• Time Out Error