CROSSTAB Function

5 posts / 0 new
Last post
talebi
Offline
Joined: 11/23/2021 - 14:15
CROSSTAB Function

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-r...
 
Thanks,
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Actually it does:

talebi
Offline
Joined: 11/23/2021 - 14:15

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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.

talebi
Offline
Joined: 11/23/2021 - 14:15

Thanks Brian, You are AWESOME!!