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.
May be as below:
Count(DISTINCT Dim_01 & Dim_02)
Thank you very much!
Remove Dim_01 from you dimension tab and see ?
Retrieving data ...