Hi,
i want to use several pivot table to build a summary table in another page of conflucence.
Is it possible to link table from a page to another?
Sorry, i am now starting to use confluence for the first time.
Hi @Gianluca Notarnicola ,
Native Confluence tools don't include pivot tables, so maybe you are using any 3rd party apps? You may want to define which app you are utilizing and wait for other responses.
Our company develops the Table Filter, Charts & Spreadsheets for Confluence app that provides the Pivot Table macro - are we talking about this macro?
If the question is how to keep the original table at one place and make different pivots from it on other pages, you may use the Table Excerpt/Table Excerpt Include macros.
If you are new to Confluence and our guess about the app was correct, you may book a live call with us - we'll discuss your use case and give some tips.
Yes i'm using Table Filter, Chart & Spreadsheet for Confluence.
I want to take the pivot table from different pages to build a new table with a summary.
I want to take tables like this (with open and closed point) and in another confluence page i want to summarize my work situation.
So, if you are on Cloud, you need to use the Table Toolbox macro for macro nesting (you wrap macros inside this shell due to the limitations of the Cloud editor).
If your tags are wrong and you are on Data Center, you may wrap macros one into another directly on the page.
So, you wrap each source table in the Pivot Table macro and then in the Table Excerpt macro. Each Table Excerpt macro should have the same name (for example, "My_pivot_123") and each page with this excerpt should have the same label (for example, "pivot_report_123").
Then on the master page where your want to show all your pivots, you insert the Table Excerpt Include macro, specify the name of your excerpts that you need to collect ("My_pivot_123" for our example) and the page label (from which pages you want to collect your excerpts).
Then in the metadata field of the Table Excerpt Include macro you may select to show the Page Title - so that each collected table will be shown along with the page name it came from and you won't be confused.
Where can I find the Table Toolbox Macro?
In the macrobrowser https://support.atlassian.com/confluence-cloud/docs/what-are-macros/
i'm trying to obtain my goal without any results.
I have some pages with pivot tables like that:
Then i have a master page with every link and the same result (i am going to write every week closed and open point). I want to create some automation to bring the analysis status from everry page and build an automatic summary. For example: i am trying to write automatically 79 "Total Complain" 69 "closed points" and 10" open points"
The idea was to collect all your pivot tables via the Table Excerpt/Table Excerpt Include macros automatically.
You'll get one big report of the following structure:
| Page Title | Analysis Status | Count |
----------------------------------------
| Page One | Closed | 69 |
---------------------------
| | Open | 10 |
| Page Two | Closed | 79 |
| | Open | 45 |
The data from your pivot tables and Page Titles will be "grabbed" and updated automatically on your master page.
I am close to final result. Now i have a table excerpt include with every infomation from source page.
I want to hide table from table except include, to have just my pivot table with result. (Is it possible to hide table from table excerpt include macros?
If you are talking about the source tables on which each pivot table is created, then you may go to the Pivot Table macro settings, locate the Options tab -> Source data and choose the "Hide tables" option.
And if you look a little bit down, you'll see the "Hide control panel" option - then the control panel of the pivot table will be also hidden.
If you do it, they won't be shown on the page with Table Excerpts and won't be collected by the Table Excerpt Include macro.
It looks like you're new here. Sign in or register to get started.
