Displaying Dimension values and Count of Dimension in single cell for a pivot table

[pasunurisandeep]

Hi Experts,

I need to display Dimension  value and Count(Dimension) in a single cell for a pivot table.

Is it possible to attain this?

 

Thanks Really Appreciate your help.

[sunny_talwar · Accepted solution]

May be like this as your expression

Dim2 & If(RowNo() = NoOfRows(), Count(TOTAL <Dim1> DISTINCT Dim2), '')

If you need it as a calculated dimension, then may be this

Aggr(
Dim2 & If(RowNo() = NoOfRows(), Count(TOTAL <Dim1> DISTINCT Dim2), '')
, Dim1, Dim2)