One line alignment in table chart

[chinmay7]

Hi,

Please find below data set:

CustID, Name, Policyholder Flag, MDMID 

1,  A           , 1                                          , 2

1 , B           , 0                                          , 3

Kindly look at above table and tell me how i should align this in one line in table chart

Required o/p :

ID  ,Name of Policyholder with Flag 1, Name of the Joint policyholder with flag 0

1,   A,                                                                ,  B                           

[Gysbert_Wassenaar · Accepted solution]

Perhaps with using CustID as dimension and two expressions:

• Only({<[Policyholder Flag]={0}>} Name)
• Only({<[Policyholder Flag]={1}>} Name)