19 Replies Latest reply: Mar 20, 2014 2:23 AM by Prashant Sangle RSS

    Count layout

    dhanu today

           Hi All,

       

          I have the data in my table as a result of an expression.How we can get the below bolded format in design level.

       

          Segement(DIM1)        Sub-seg(DIM2)          Exp1              >=50000 and <=100000           >100000  and <=150000

           TC                              TC-Azc                   90000                1                                            -
           TC                              TC-Apc                  150000                -                                           1

           TC                              TC-BCP                 100000               1                                            -

           TC                              TC-BCL                 150000               -                                              1

                                                                     Total :490000         2                                             2

       

          The Sub-seg field is not required in table level as a dimension.So then

       

       

      Segement(DIM1)          Exp1              >=50000 and <=100000           >100000  and <=150000 

           TC                          490000               2                                           2
                                                                     

        Thanks in advance,

         Dhanu