Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
560
Multiple Summary Rows in single band
posted

Is it possible to have multiple summary rows in a single band. I have data like below and need to show Summaries as Subtotal for each unique ColA value. Is it possible to show as below without manupulating data in underlying datasource.

 Thank you

 

ColA       ColB           Col C

1              a               2
1              b               5
1              c               3

              SubTotal    10

2               x              1
2               z              2

                SubTotal    3

3                i              4
3                j             10
3                k             4
3                i              5
                 Subtotal   23

 

Parents
  • 145
    posted

    ColA       ColB           Col C

    1              a               2 
    1              b               5
    1              c               3

                  SubTotal    10

    2               x              1
    2               z              2

                    SubTotal    3

    3                i              4
    3                j             10
    3                k             4
    3                i              5
                     Subtotal   23

     

    From the above grid, is there a way to grab all the summaries into a different grid. Like for each unique entry in column A the subtotal value to be displayed in a different grid.

Reply Children
No Data