Totals for each break

[ddsrini]

Hello All
I have a report which has two breaks. One for Region, One for Product Type. When I refresh the report everything works fine. For example if a region has two product types, then I get twp pages one for Region A and Product Type P1 and one for Region B and Product Type P2. NOw on each page I want to show totals of a measure. When I include the break footer I get the totals for all the pages in the reports and not that one page.

Can some one please suggest something to get this to working the way I want it to

THanks

 

[blom0344]

Look into the subject of 'calculation contexts'.
You will find that you can override the standard context that reporter applies by adding an extension to a summary expression, like:

=sum(<revenue>) In (CurrentPage)

T. Blom
Information analyst
tbl@shimano-eu.com