9 Replies Latest reply: Sep 13, 2017 8:30 AM by Anand Chouhan RSS

    Count straight table rows

    Dinesh Manahoran

      Hi All,

       

      Kindly help me to count the number of rows in a straight table.

       

      Example:

      Straight_table.PNG

      Note : '-' is Null in the above screenshot.

       

      I have tried count(distinct Dimension) , I am getting 5.But the expected count is 3 excluding Nulls.

       

      Thanks

      Dinesh M