Count Distinct

[#1]

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)

Thanks!

[trdandamudi]

May be as below:

=count(Total DIM_02)

[swuehl · Accepted solution]

Try

Count(DISTINCT Dim_01 & Dim_02)

[vishsaggi]

Remove Dim_01 from you dimension tab and see ?

[#5]

Perfect, Stefan!

Thank you very much!