Topic
3 replies Latest Post - ‏2013-05-14T10:25:38Z by TimTam18
TimTam18
TimTam18
11 Posts
ACCEPTED ANSWER

Pinned topic Active Report: Summary line gets hidden on value filter

‏2013-05-02T11:40:43Z |

Hi,

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.

 

Active Report

Attachments

  • DanielWagemann
    DanielWagemann
    850 Posts
    ACCEPTED ANSWER

    Re: Active Report: Summary line gets hidden on value filter

    ‏2013-05-02T12:25:59Z  in response to TimTam18

    The product has a summary feature for this.  If you click on the toolbar Summarize Icon, at the bottom you will see a section called Summarize in Output.  If you use the Total from there, instead of the Query Summarize at top, the Active Report Totals will change as you filter.

     

    Attached please find your modified sample spec with this in place.  I have tested it here and the totals now change as expected.

    Attachments

    • OpherB
      OpherB
      677 Posts
      ACCEPTED ANSWER

      Re: Active Report: Summary line gets hidden on value filter

      ‏2013-05-02T19:12:30Z  in response to DanielWagemann

      I'd like to add to Daniel's reply by saying that if you were only using the Query summary, and the Query was filtered to show only one value, the summary becomes useless - it's the same numbers.

      Therefore, changing the output to use the "Summarize in Output" option would be the appropriate way to force the summary to appear all the time, even if only one data value was being reported.

      Opher

       

    • TimTam18
      TimTam18
      11 Posts
      ACCEPTED ANSWER

      Re: Active Report: Summary line gets hidden on value filter

      ‏2013-05-14T10:25:38Z  in response to DanielWagemann

      The solution works perfectly.. thanks Daniel / OpherB!!!