I am using Qlik Cloud Reporting and I have an excel template. I have created page levels to cycle through the Currency Type field to create 3 Excel Tabs- Functional, Reporting, and Original.
I want to insert a pivot table from the Reporting tab, but that gets created on the fly by the page level tag.
I can insert a pivot table by the standard way - adding columns from the table, but if I filter to Reporting Currency Type the page level only Reporting. If I do not filter the Currency Type I get the three Tabs - Functional, Reporting, and Original but the pivot table uses the first tab (Functional)
How can I insert a pivot table from a tab that is created from a page level on the fly?
