CROSSTAB Function

talebi

Forums

Hi everyone,
 
Do we have "CROSSTAB" function in IDEA? I know we can make it via pivot table but the problem is IDEA does not create macro for a pivot table!
I am looking for this function to make it manually and then save it into a macro for future work.
The link below is a description for crosstab query:
https://support.microsoft.com/en-us/office/make-summary-data-easier-to-…
 
Thanks,
 

talebi Tue, 03/01/2022 - 17:36

Thanks Brian,
I really appreciate your support.
Now I know how to create a macro for the pivot table result. So, my macro also need the results to be sent in IDEA database, or export the results directly to a folder in excel format. Do you have any tips?
Thanks,
 
 

Brian Element Tue, 03/01/2022 - 19:01

To export the database to IDEA make sure the following line in the script it set to true:

task.ExportToIDEA True

If you want to send it to excel you need to export it to IDEA first and then save it.  You can't do it directly.