1 Reply Latest reply on Jul 11, 2018 4:38 PM by swaroop.gantela

    Concatenating rows in single row

    Sunil Gopinath

      HI,

       

      I am working with the data source (Percentage and Product) where percentages results in multiple same value. I want to display the multiple values in a dashboard as KPI but the issue is that as the space is small I am unable to fit the data's and also I need the product in the row.

       

       

      I have tried

       

      IF [Lowest OTD] = [Lowest OTD]

      THEN PREVIOUS_VALUE("") + IIF(INDEX()==1, "", ", ") +

      ATTR([Profit Center])

      END

       

      which ended in the following result

       

       

      I want to display all the products in a single row.

       

      Regards

      SL

        • 1. Re: Concatenating rows in single row
          swaroop.gantela

          Sunil,

           

          This is a simplified workbook, but maybe it can work for your setup.

           

          I think you were almost there.

          It looked close to what I was following in:

          Re: create new dimension

           

          I used this to concatenate:

          IF ATTR([Lowest Value])="Lowest Value" THEN

              IF FIRST()=0 THEN ATTR([Dimension])

              ELSE PREVIOUS_VALUE("") + ", " + ATTR([Dimension])

              END

          END

           

          Then this to get just the final tag:

          IF ATTR([Lowest Value])<>"Lowest Value"

          THEN ATTR([Dimension])

          ELSE WINDOW_MAX([Concatenate])

          END

           

          The table calculation settings are shown in the below screenshot.

          Attached in the forum thread is the workbook v.10.3.

           

          275433concat.png