4 Replies Latest reply: Feb 4, 2016 12:29 PM by Gysbert Wassenaar RSS

    Group fields into one field in dashboard

    Soukaina EZZENFARI

      Hello,

      In my DATAMART FINANCE, I need to visualize many fields into one field.

      I have Dimension of  Accounts:

                - ID_COMPTE

                -COMPTE                     : (for exemple : 712111)

                - CODE CATEGORIE 1:       (  7  )

                -CODE CATEGORIE 2:        ( 71 )

                -CODE CATEGORIE 3:       ( 712 )

                -CODE CATEGORIE 4 :      ( 7121)

       

      Id_comptecompteCODE CATEGORIE 1CODE CATEGORIE 2CODE CATEGORIE 3CODE CATEGORIE 4
      17121117717127121
      27122207717127122
      37143207717147143


      I need to visualize the revenu by all the " CODE CATEGORIE " but in the same field, i'd like to have a report like this:



      Revenu
      710000
      711000
      712100
      7121110
      7121111

       

       

      Can anybody tell me if its possible or not  ?

       

      Thank you.