i Need my data to be in single row in a straight table.

[sbkumar]

i Need my data to be in single row in a straight table.but i am getting date in different rows.i am attaching the my output image.

i need in only single row.

[jonathandienst]

You are getting the "extra"rows because of the second dimension. Remove [Payer Channel] from the chart.

[sbkumar]

if i remove that dimension it is showing as above..

the below expression is used for payer1,

expression is =if(aggr(rank(sum({<C13W={1}, [Therapeutic Category] = {'INSULIN'}>}TRX)/sum({<C13W={1},[Therapeutic Category] = {'INSULIN'}>} Total <IMS_ID> TRX)),IMS_ID,[Payer Channel])=1,[Payer Name])

[jonathandienst · Accepted solution]

Its really hard to say based on the very limited information you have provided. so these are guesses:

=MaxString(if(aggr(rank(sum({<C13W={1}, [Therapeutic Category] = {'INSULIN'}>}TRX)/sum({<C13W={1},[Therapeutic Category] = {'INSULIN'}>} Total <IMS_ID> TRX)),IMS_ID,[Payer Channel])=1,[Payer Name]))

=Concat(Distinct if(aggr(rank(sum({<C13W={1}, [Therapeutic Category] = {'INSULIN'}>}TRX)/sum({<C13W={1},[Therapeutic Category] = {'INSULIN'}>} Total <IMS_ID> TRX)),IMS_ID,[Payer Channel])=1,[Payer Name]), ', ')