Percentage By Group Total Report- A step by step guide

Products

• Cleverpath Reporter
• EUREKA:Reporter
• EUREKA:Strategy

Issue/Introduction

---

Percentage By Group Total Report- A step by step guide

Environment

Release:
Component: PORTAL

Resolution

These are the general steps to create a Percentage by group total report using the Global Sports sample database included with CleverPath Eureka Reporter. In this case you will need a parent report as well as a child report. It is assumed that the user has some basic knowledge about creating reports with CleverPath Eureka Reporter Designer

1. Create a parent report
      Add a group header on Region. Place the Region column on the region group header
      Place Country and Line_Item_Amt on the detail area. Change Line_Item_Amt to be a Sum.

    

2. Create a child report with two prompts in the page Header area
      1 for the RegionPrompt
      1 for the CountryLineItemAmtPrompt
      Place Line_Item_Amt in the detail area and put a Sum on it
      Filter When Region = RegionPrompt
      Place a custom in the detail area called Percentage that has as a value:
         (CountryLineItemAmtPrompt/Line_Item_Amt)*100

    

    

3. Place child report on the parent report in a detail area.
   Fill in the answers to the prompts in the child report icon using fields from the parent.
         RegionPrompt = Region from group header area
         CountryLineItemAmtPrompt = LineItemAmt from detail area.
   Right click on the child icon and choose Hide Togle.

    

    

4. Next place the Child data object (percentage) on the detail area of the parent report.

    

    

   Create Region group footer.
   To add the group totals copy Sm_Line_Item_Amt from the detail area and paste it in the Region Group footer.

    

    

   Here is an explanation of the steps we just took in this report.For each detail line (Country), a child report will run and

   1. Calculate the total line_item_amt for a Region
   2. Calculate a percentage of the Region total for that Country
   3. Send percentage back to the parent report.