0 Replies Latest reply: Mar 26, 2018 1:53 AM by Capricon User RSS

    blank row in pivot table

    Capricon User

      I have this kind of data in table .. in script i megerd two fields like this

       

      [HeadMAIN]&'.'&[SUBCLASS] as Merged

       

      column1         column2

      Product.P1      4

      Product.P2      234

      Product.P3     124

      Product.P4      234   

      Catergory.C1   12

      Catergory.C2    94

      Catergory.C3     54

      Catergory.C4      45    

       

       

      now i want to get one additional blank row after each headmain  how i do this

      column1         column2

      Product.P1      4

      Product.P2      234

      Product.P3     124

      Product.P4      234

      Product           

      Catergory.C1   12

      Catergory.C2    94

      Catergory.C3     54

      Catergory.C4      45

      Category