Display ID and Name instead of the ID count column

[24_02_SRR]

Hi All,

We have one column called Count of ID in Pivot table, but the end-user wants to display the ID&'-'&Name  instead of the ID count.

Ex:

Programs	Level	Count of ID
A	L1	3
B	L1	2

Count({<Level={'L1'}>}ID)

Programs	Level	ID&Name
A	L1	153-AAA
A	L1	145-BBB
A	L1	167-CCC
B	L1	187-DDD
B	L1	145-BBB

How do we get that in ID&Name in measure column

[BrunPierre]

Can you elaborate?

[24_02_SRR]

We are displaying ID count as one column. instead of the count column they want to see the actual Employee ID and Name

Ex: Count value is 4 means, they want to see the who are the 4 members 

[BrunPierre]

Add this in the load script,

ID & '-' & Name as "ID_NAME"

and this for the expression

=Concat(DISTINCT {$<ID_NAME={"=Count({<Level={'L1'}>} ID) > 0"}>} ID_NAME,' ,')

[24_02_SRR]

I'm getting blank column for this measure.

[BrunPierre · Accepted solution]

Retry

---

=Concat(DISTINCT {$<ID_NAME={"=Count({<Level={'L1'}>} ID) > 0"}>} ID_NAME,' ,')

[24_02_SRR]

Thanks for your help. It's working but I'm getting result like 153-AAA,145-BBB,167-CCC

but I want 

153-AAA

145-BBB

167-CCC

which means Space or line space. Is there any function to create line level space

[BrunPierre]

Tmp:
LOAD * ,
ID & '-' & Name as "ID_NAME"
Inline [
Programs,Level,ID,Name
A,L1,153,AAA
A,L1,145,BBB
A,L1,167,CCC
B,L1,187,DDD
B,L1,145,BBB];

NoConcatenate
LOAD Programs,
Level,
MaxString(ID_NAME) as ID_NAME

Resident Tmp

Group By Programs, Level, ID;

DROP Table Tmp;

EXIT SCRIPT;

[24_02_SRR]

Thanks for your immediate replies