dynamic table o pivot table

ortizmario6025…

Forums

Hello, I am creating a pivot table in idea, and the script runs fine. The question is, how do I send this table to Excel through other scripts, since IDEA does not save it. any idea how to do it?, I want to automate all the tasks, but this is a small problem.

Brian Element Thu, 09/15/2022 - 08:37

You would have to first export it to IDEA which you can do through the pivot script and then take the IDEA file and export it to Excel.  There are limitations in thet you can only have one field selected as a row and a column, if you have multiple fields I don't think you can perform an export to IDEA.