This content has been marked as final. Show 5 replies
I have a pivot table:
Column dimensions: country, tax_class
Row dimension: if(status=0, age) //suppress null values
Measure #: count(distinct product_name)
I want to show the percentage against the totals at the top. I tried count(distinct product_name)/count(total <age> distinct product_name), but it shows the following:
There are some dash '-' in the table. They are supposed to be 0. Why does it show - instead of 0? Can this be fixed?