4 Replies Latest reply: Aug 17, 2016 4:58 PM by Fernando Martini RSS

    Count Distinct

    Fernando Martini

      Hi,

       

      In the image bellow I'm doing a count Distinct over DIM_02.

      As you can see, the TOTAL is 4 because there's 4 different values for DIM_02.

      But now I need to show in a bar chart the sum of the totals, like in the second image.

       

      Expression:

      =count(DISTINCT DIM_02)

       

      01.JPG02.JPG

       

      Thanks!