Hide Table Rows that have zero values in all columns

[cgT]

Hi everyone,

I'm trying to exclude any results in my table that have zeroes across all columns/measures.

The first thing I tried was to untick 'Include null values' in the dimension options.

Is anyone able to guide me in the right direction?

Thanks

[Lakshmanan]

Under Add-Ons - > Data Handling ->Uncheck "Include Zero Values".

Please mark as resolved if it solved the issue.

[cgT · Accepted solution]

I had tried this too but thanks for the reply.

I have found that a measure at the end of the table columns had a value in it, once I deleted that column it worked.

Many thanks.