4 Replies Latest reply: Jul 26, 2013 3:23 PM by 1009219 RSS

    Creating an Intersection Form with Subtotals

    1009219

          
      Hi,

       

      We have been having issues with our Smart View Intersection Report, so I created a form version of the Intersection report. The intersection form / report displays all the intersections where there is data for the selected Entity, Scenario, Version, and Year. The form is built to retrieve all intersections with data based on the user variablers of the user. For example, &Entity, &Scenario, &Version, &Year.

       

      How do I create the same Intersection form with Subtotals for each Level 0 Entity? The issue I'm having is that it is a user variable, so I can't have a one row for the Level 0 Entity and then a second row with just the Entity one level higher and repeat that for all Level 0 entities. Is there a work around?

       

      Thanks in advance! Very much appreciated.