Pivot table - How to add filter
ClaudineBournival
Forums
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
Hi Claudine,
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