Calculated dimension with count expression and text

[#1]

Hi,

I am trying to create a Calculated dimension, which concatenates a text field(Secondary theme), with the expression : count(distinct ........ )

I have attached the example I am working on.

I would like the Final Calculated dimension to have the Secondary Theme concatenated with COUNT(distinct  [Unique Question]) , in brackets.

Any ideas would be greatly appreciated!

Thanks.

[kaushiknsolanki · Accepted solution]

Hi,

     Use this as calsulated dimention.

     =[Secondary Theme] &' '& aggr(count(DISTINCT [Unique Question]),[Secondary Theme])

Regards,

Kaushik Solanki

[#3]

Thank you...Works perfectly!