Skip to main content

Pivot Table Result - Send to IDEA Database

Hello Group Members,
 
We are familiar with the Pivot Table and it’s utility in IDEA.
 
It’s an invaluable source of insight and provides the foundation for pertinent questions to analytic stakeholders through a simple and convenient drag and drop facility into the Pivot Sheet / View.
 
The default output of the Pivot in IDEA is a Result / View under the Properties Toolbar (right side of the IDEA screen) for the active database. At times as a user you may wish to perform further Analytics on the Pivot Result to better crystallise your output. For this, one can convert the Pivot Result to an IDEA database by clicking on the black drop down arrow in the Pivot Result Toolbar and change the option to Send to IDEA Database. Once the change is done just click on the Send button to the left of the black drop down arrow in the Toolbar and receive your Pivot Result as a Pivot Database.
 
Best Regards
 
Group Admin Team

pomarquis Wed, 02/19/2020 - 13:09

Hi again Brian, i found this post regarding my question previoously asked.
 
What if my "send to an IDEA databse" option is left gray and i can't click on it ?
Is there a way to fix that ?
 
Thanks !
 

Brian Element Fri, 02/21/2020 - 07:03

In reply to by pomarquis

You problably have multiple fields selected for the row, column or data.  IDEA only allows you to have one field selected for each, if you have more than one you can't send create a database for it.