I have a dimension that contains multiple results. I need to show the result on a dashboard in one row separating the results by a comma.
From:
Best Execution
Churning
Client Classification
Communications with Clients
To:
Best Execution, Churning, Client Classification, Communications with Clients.
Any ideas?
TIA
3 answers
Hi @Tanya Zilberman , well try the solution below
create a calculated field shown in the code snippet below
IF FIRST()=0 THEN MIN([Risk Level]) ELSE PREVIOUS_VALUE(MIN([Risk Level]))+','+
MIN([Risk Level]) END
Drag [Risk level] to detail, drag the new calc. field to text and compute using [Risk level].
Create another calculated field tag Last
LAST()=0
Drag this to filter and check True.
Sample workbook attached for reference
