Test if a pivot table has data or not so I can hide it if it has no data?

[canoebi99]

Hi all,

I have a couple of pivot tables that I am using on a report and I only want them to print on the report if they actually have some data,

I am thinking I may be able to use the conditional show on the layout tab of the object but I don't know what code to use here to test if the chart actually has any data to display.

Can anyone advise how I might achieve this please?

Many thanks in advance,

Ben

[#2]

Generally we can Hide/Show any object on conditional

For Pivot table --> Properties --> Layout --> Show --> select conditional and write down your expression based on your requirements

The other method is enable the calculated condition on General Tab

[#3 · Accepted solution]

Hi Ben,

Yes you are right.You can hide/show an object by using "Conditional" on Layout tab.

In the Conditional, use any of the expression from your table and make them non zero.

For Eg:

There is an expression Sales, then in Conditional write

Sum(Sales) <>0

This way the table will be shown only when there is any data.

Hope this helps!