2 Replies Latest reply: Dec 7, 2016 7:51 AM by Zikun Zhu RSS

    Two expressions in pivot table row by row

    Zikun Zhu

      I want to create a pivot table looking like this:

      Capture.JPG

      Dimensions: country, pass_fail_status

      Expessions: count(id). count(id2)

      Any idea how to achieve this?

       

      I'm able to show one expression only. If I add the second expression, it becomes two tables.

      I also tried using normal table, which solved the problem, but the presentation is not nice. The country names will show twice.