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,
talebi
Offline
Last seen: 2 weeks 10 min ago
Joined: 11/23/2021 - 14:15
Actually it does:
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,
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.
Thanks Brian, You are AWESOME!!