Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Clubbing rows for a data field

Hi All,

 

I have created a report and have a question regarding the same.

 

I have an opportunity mapped with 7 different states thus resulting in 7 different rows in my visual.

 

Is there a way that I can show all the states (comma seperated) in a single tab so that I have only 1 row for my opportunity?

 

Regards,

Himanshu

 

 

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , how about using concatenatex

     

    concatenatex(Table, Table[Status])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      How to seperate the states by comma?

       

      Also should I use "Split Column" to select the initials of the state rather than showing the complete name?

       

       

      Measure Used: 

      One State Column = CONCATENATEX(View_Opportunity, View_Opportunity[State])
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        amitchandak is this correct or there is any other way?

         

        One State Column = CONCATENATEX(View_Opportunity, View_Opportunity[State] & " ",",")