Hello everyone,My file contains the number of tickets sold, the ticket price, type of payment, type of transaction, type of ticket and the date of the transaction.Using IDEAScript, I would like to produce 6 different tables showing the number of tickets and the entire amount for a particular type of payment, either for a specific date or for a particular type of ticket, ...How can we add filters in the script of the pivot table?PS the interest of making a script: I have to do the same job for 25 files.Thank you
Images:
Files:
Hi Claudine,
Unfortunately the only way I know how to do this now is to first create an extract and then create the pivot table. It is a great suggestion and I have forwarded it onto IDEA so maybe they can add this in a future version.
Brian