How can I use the Pivot Table macro in Confluence to count empty cells as 0?

[Karen Knight]

I am trying to create a chart using a pivot table and am having trouble getting the Pivot Table macro to count empty cells as 0 instead of 1. Is this possible?

[Natalie Paramonova [Stiltsoft]]

Hi Karen,

If you use the Table Filter and Charts app for building a chart and a pivot table, you need to filter not empty rows with the help of the Table Filter macro and then count the number of rows with the help of the Pivot Table macro.