Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
With reference to the image above, I would want to count distinctly the values under the column Mobile, DOB & Mail, and display as highlighted in the light blue background.
I tried, IF(Dimensionality()= 3, count (distinct Mobile), but results were incorrect.
Can you elaborate on what was incorrect? What did you get and what were you hoping to see? Can you may be provide a sample to check this out?
Hi Sunny_talwar
The results were null '-' and the desired result is attached below. Essentially, where the dimension value is not blank/null/empty count and display totals.
What if you just used Count (DISTINCT Mobile)?