I want to count any value which is not zero. I realized by default if I use CNT in tableau, it will still count for anything contained in my excel (incl. 0). And I want to get rid of the 0 empty cell.
Can anyone help? Thanks.
9 answers
Hi,
Thanks for your reply.
I'm using the CNT functionality in stead of a calculation set. Please see the attached screenshot.
So I was wondering if there is a way to count non zero within the CNT default measure.
