How do I add a script or event to selected rows and columns in a pivot table in AIV?

To add a script or event to the selected rows and columns in a pivot table in AIV, follow these steps:

1. Create a Pivot Table:

   • Begin by creating a pivot table that includes rows, columns, and aggregation. For example, you can set the row to Country, the column to Month, and the aggregation to Sum of Price.

2. Access the Row Settings:

   • Click on the Settings icon next to the row name where you want to add the script/event.

3. Enable the Script Option:

   • In the settings menu, check the box labeled 'Script'. Once checked, a text area will appear at the bottom of the window for you to input your script.

4. Write Your Script:

   • Enter your script in the provided text area. For example, you might use the following sample script to change the tab and apply a filter based on the clicked country name:

5. javascriptCopy code
   var a = '{{country}}'; console.log(a); var tab = new CustomEvent("aiv-change-tab", { "detail": 1 }); window.parent.dispatchEvent(tab); setTimeout(function(){     var filter = new CustomEvent("aiv-filter-call", { "detail": {"country": a} });     window.parent.dispatchEvent(filter); });
   

6. Save Your Changes:

   • After writing your script, click the Accept button to save your changes.

7. Test the Script:

   • Switch to Preview mode to test your script functionality. Click on the relevant data in the pivot table to see if the script executes as intended.
     
     For any inquiries, please reach out to our support team at support@aivhub.com.