5 Replies Latest reply: Dec 20, 2016 8:06 AM by Sunny Talwar RSS

    Show percentage in pivot table

    Zikun Zhu

      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:

      pivot.JPG

      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?