« Execute Batch Processing   |   Using Excel-Link Functions in Macros »

Execute Pivot Query

This manual is in pilot operation.

You can specify search criteria to retrieve fusion_place ledger data into an Excel sheet and display it as a pivot table. Follow these steps:

  1. On the fusions ribbon in Excel, click the PivotQuery button.

    (For the first connection or when a certain amount of time has passed since login, user authentication will be required. Refer to Connecting to the Server for authentication procedures.)

    A search criteria input screen like the following will appear:

    pivot query criteria v12.1

  2. Specify the search criteria in the above screen and click the Execute button. A pivot table will be created. The generated table can be analyzed using standard Excel pivot table operations, such as swapping row and column axes.

    In the "Filter" table at the center of the screen, you can double-click a row for each dimension, or select a row and click the Edit Filter button to display a screen for modifying filter conditions for each dimension.

    For details on each search criteria item, refer to " Pivot Query Criteria."

Saving and Loading Search Criteria

You can save the specified search criteria to a file. Saved search criteria can be loaded and reused multiple times. Saving and loading can be performed using the Save Criteria and Load Criteria buttons on the search criteria input screen.