Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table:
Column dimensions: country, tax_class
Row dimension: if(status=0, age) //suppress null values
Measure #: count(distinct product_name)
Measure %:
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:
Another question:
There are some dash '-' in the table. They are supposed to be 0. Why does it show - instead of 0? Can this be fixed?
Try count(distinct product_name)/count(total <country,tax_class> distinct product_name)
Try count(distinct product_name)/count(total <country,tax_class> distinct product_name)
Wonderful. This works!
Another question if you don't mind:
There are some dash '-' in the table. It is supposed to be 0. Why does it show dash instead of 0? Can this be fixed?
uncheck suppress zero values
I already check "show zero values". But some zero values are shown; some are not
Look here to check out the difference between null and missing value