4 Replies Latest reply on Jul 26, 2013 8:23 PM by 1009219

    Creating an Intersection Form with Subtotals




      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.