3 Replies Latest reply on Jan 3, 2019 4:58 AM by tian.yang.4

    How to bring one dimension under another dimension - see details

    vibin.venugopal.0

      I have 2 columns as given below. I wanted to bring the sales sub category column values under sales category. I am connecting to a data source in the server so I am not getting the pivot option. I tried some grouping as well even it didn't

       

      Any help on this is highly appreciated.

        

      Sales CategorySales Sub Category
      Product CostProduct Cost-1
      Product Cost-2
      Product Cost-3
      Product Cost-4
      Product Cost-5
      Manufacturing CostManufacturing Cost - 1
      Manufacturing Cost - 2
      Manufacturing Cost - 3
      Manufacturing Cost - 4

      Manufacturing Cost - 5

       

      I am looking for a result like this.

       

       

      Sales Category
      Product Cost
      Product Cost-1
      Product Cost-2
      Product Cost-3
      Product Cost-4
      Product Cost-5
      Manufacturing Cost
      Manufacturing Cost - 1
      Manufacturing Cost - 2
      Manufacturing Cost - 3
      Manufacturing Cost - 4
      Manufacturing Cost - 5