How can I suppress dimension headers for charts with no rows?

[Anonymous]

I have a pivot chart that displays Product and Sales. Suppress Zero-Value is checked. Sales can be filtered by Office. If I select an office that has zero sales, no rows display, but the Product header displays. How can I not have the header display?

I use this chart to print a report per office (using Loop page over Office field) and do not want to print unnecessary (blank) reports.

[#2]

Hi,

This is simple.

Go to Product label name and type ' ' (space).

Warm Regards,

Karthikeyan.

[Gysbert_Wassenaar]

You can't hide the header. But you can hide the entire pivot chart if there are no rows to show. On the Layout tab you can check the Conditional option (under Show) and add an expression like =sum(sales). If the sum of sales is zero then the chart will be hidden.

[Anonymous]

Thanks for your response, but that would hide the headers for all my rows.

[Anonymous · Accepted solution]

Perfect! That was what I needed. Thanks for your help.