Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be as below:
=count(Total DIM_02)
Try
Count(DISTINCT Dim_01 & Dim_02)
Remove Dim_01 from you dimension tab and see ?
Perfect, Stefan!
Thank you very much!