Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]), ', ')
You are getting the "extra"rows because of the second dimension. Remove [Payer Channel] from the chart.
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])
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]), ', ')