Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cgT
Creator
Creator

Hide Table Rows that have zero values in all columns

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

Labels (2)
1 Solution

Accepted Solutions
cgT
Creator
Creator
Author

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.

View solution in original post

2 Replies
Lakshmanan
Partner - Contributor III
Partner - Contributor III

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

 

Please mark as resolved if it solved the issue.

cgT
Creator
Creator
Author

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.