The Source Table:
Insert the Page Properties Report macro to show summary information from one or multiple pages on another page and configure its parameters.
The app works only with the rows of Page Properties Report currently displayed on a page. The app can't influence or make changes (such as filtering not displayed data) to Page Properties Report when the pagination is enabled in the macro.
In case you want to process all data, you need to increase the number of rows to display in the Page Properties Report macro browser.
Pivot Table & Page Properties Report
3. Add the Pivot table macro to the Page Properties Report macro with filtered data.
Pivot Table allows you to summarize your table data and aggregate it by date periods and number ranges.
You can select the following operations: Sum, Count, Min, Max, Average, Literal.
7. Save the page.
8. Change the filtration criteria, the pivot table and chart parameters on the fly.
The changes will be automatically applied to the data from the Page Properties Report macro.
Table Transformer & Page Properties Report
2. Place one or multiple tables within the macro body to merge, look up them or to perform custom calculations.
Here's an example on how to combine Table Excerpt Include and Page Properties Report with Table Transformer.
The Page Properties Report macro outputs just one row from the page.
If you need to pull tables with more then one row, you can use the Table Excerpt and Table Excerpt Include macros instead of the Page Properties and Page Properties Report macros and merge tables with the help of the Table Transformer macro.
You can use the Page Properties Report macro with each of the macros separately or combine them according to your needs.