• Post Reply Bookmark Topic Watch Topic
  • New Topic

datatable group by  RSS feed

 
Joe Jose
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

How can I find the sum of group by columns in datatable ? For example :

header1 hearder2 header3

parent 1 child1 child11
child2 child22
Total total1 total2

parent2 child1 child11
chlild2 child22
Total total1 total2

Anyone has an idea how can find 2 totals in one datatable ? I am using t:datatable.
Please help me. I am stuck on this. I am getting the sum of the two columns as a separate query. I am confused how can I work out this.

Thanks,
Joe.
 
Joe Jose
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any help on this please ?
 
Richard Green
Ranch Hand
Posts: 536
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
see http://balusc.xs4all.nl/srv/dev-jep-dat.html#NestingDatatables
 
Joe Jose
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Thanks Richard. Nested table works. But still I cannt get the total as I expected. I tried to use footer for displaying the group total. But the footer doesn't seem to work.
Have you tried ? Or any idea ? Please help me.

Thanks,
Joe.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!