I have a minimal report as shown below. On top is a Data List Box which feeds from the Product Line and below is a simple crosstab showing Product Line as rows, years as columns and Revenue as measure. The crosstab is tied to the Data List Box via a Container Filter in the Interactive Behaviour settings.
It works as expected, except that whenever we select the Product Line, the crosstab's Summary line will disappear. Understand that the technology under Active Report does not really re-calculate numbers (hence it may choose to hide the summary line to avoid confusion) - however is there any way to get around this issue?
Apparently it is a basic business requirement that the Summary line should remain when the filter applies.
Attached is the report specs in v10.2 - this works with the standard GO warehouse package
Thanks for any suggestions.