In my report i have columns Region.organization,and category desc.The user wants to see the sale information of each category separately organization wise,such as he want to see western regions and organizations id's belongs to that region.I have grouped all three columns and sectioned on category desc.i have got each region and organization's associated with it and subtotals such western region xxxxx.Now the end user wants to see all region's summary totals with each category.for ex
Videos
----------
western region| jksx
| kkk
-----------
subtotals---------------
southern region|jkm
lkil
pmp
subtotals------------------
he want summary of these subtotals in each section.I have tried adding list footers and other things but nothing seems to be working.Please Help.Thanks
Did you ever get around this issue? I have the same problem. I have a crosstab report with users and their reported workhours. I created a section based on the User so the end user can view the report based on user. They also want to know the total working hours for each selected users and I can't find a solution, how to show the total of the subtotals in each section.
I am hoping to revive this post. I have a report studio report that I have sectioned (as opposed to grouping). If I add a total, it just gives the grand total of all sections. Is there a way to add a section total?
Why not override the definition of the subtotal by an aggregate within the context?
total([measure] for [sectioned_dataitem])