nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I use the output of a pivot table as a page property label

Patrick Mayrhofer

I would like to use the Output of the pivot table below as a label for the page properties:

Then use this label to display the content (2h) in a report from multiple pages.

It works fine if I manually write a table but not with the pivot labels.

I have tried both, "Total" and "Sum of Time Spent".

Any ideas?

Accepted answers

All comments

Katerina Kovriga {Stiltsoft}

Hi @Patrick Mayrhofer ,

As I understand, you are trying to wrap your pivot tables into the Page Properties macro and collect a report with the help of the Page Properties Report macro. And the problem is that Page Properties doesn't recognize the Pivot Table macro.

We suggest using our native macros - Table Excerpt and Table Excerpt Include macros. They work similar to the Page Properties Report macro but have more advanced features.

Patrick Mayrhofer

Hi @Katerina Kovriga _Stiltsoft_ ,

Thank you for your answer.

Yes, I think you have summarized correctly. I have multiple Project Summary Pages, each one has Page properties for Project Status fields, project trafic lights, next steps and also sum of time spent last week. Selected page property fields from all our project summary pages are then displayed on a seperate Page via the page properites report. Only the sum of time spent field is a pivot table. I can put the whole pivot table in a page property field which looks ugly but I cannot display just the one value I need.

Since it is already setup this way it would be much easier for me to use the page properties.

If that is not possible at all is there an example for the table excerpt achieving something similar?

Katerina Kovriga {Stiltsoft}

The Table Excerpt/Table Excerpt Include macros are pretty similar to the Page Properties/Page Properties Report macros but allow you to collect multiple-row tables.

Wrap your Pivot Table macro into the Table Excerpt macro:

Fri 4-1.png

And give it a unique name:

Fri 4-2.png

Then collect your Excerpts with the help of the Table Excerpt Include macro:

Fri 4-3.png

Fri 4-4.png

The last step is to merge your tables with the help of the Table Transformer macro:

Fri 4-5.png

Fri 4-6.png

You may also check the field "Show page titles of included tables" into the Table Excerpt Include macro settings and you'll get an additional column with a link to the page with the source table.

Fri 4-7.png

This function has been working perfectly well for manually created tables and from the 7.3.6 version was introduced for Pivot Tables - please update your app.

Katerina Kovriga {Stiltsoft}

If you have any specific questions, I can suggest raising a support ticket, where you'll be able to attach screenshots.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server