7 Replies Latest reply: Oct 12, 2015 5:02 AM by Uday P RSS

    Is it possible to show a dimension and its associated values in single row if the first dimension is repeating?

    Uday P

      Hi Everyone,

      I have a table in which a particular dimension(MATNR) has ID's which are repeated if there are multiple values associated to a single ID when used in pivot or straight table. Is it possible to show  the data in single row for each MATNR by using only the script without repeating the MATNR values by using the sum of values if it is a numeric value and if it is a date, only one date and if a value is repeating only one value relating to that field and MATNR.

       

       

      I have attached a qvw which I am having issue with and it is in a straight table.