Default value on Pivot Table

[Sidharth]

Hi,

I have multiple of these on a page:

PivotTable -> Table Filter -> Table Excerpt

The PivotTable type is Count so I'm displaying a number when it renders.

This works well until the Table Filter does not return any records at which point the PivotTable displays the empty table. I've set all the "hide" values like hide all content, totals, control panels etc. but unfortunately nothing works.

I've also tried to see if there's a way on the Table Filter but alas I don't think so.

Has anyone seen this issue and knows how to fix it?

[Stiltsoft support · Accepted solution]

Hi @Sidharth ,

It seems that you talk about our Table Filter, Charts & Spreadsheets for Confluence app.

The described behavior is an expected one: as you have an empty table after the Table Filter macro (a header and no rows), your pivot is empty.

As a workaround, you may check the "Show single-cell result as text" option.

It will show 0 in case of an empty single-cell pivot and won't affect real populated pivot table.

If you have further questions regarding the app, please contact our support portal directly.

[Sidharth]

Ah ok, thank you!