Count display items from the dimensions as expressions in a pivot table

[BrunPierre]

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.

[sunny_talwar]

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?

[BrunPierre]

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.

[sunny_talwar]

What if you just used Count (DISTINCT Mobile)?