2 Replies Latest reply on Nov 14, 2012 10:11 PM by JimBrear

    Subsummary Help needed

    JimBrear

      I feel stupid asking this but I cannot work it out.

       

      I am reporting services provided to clients. Service codes range from 01 to 22.

       

      Depending on the age of the client the service will be Federal or state government funded.

       

      I set up the report

       

      I have a summary field Total services

       

      Layout looks like this:

       

      Sub Summary Service code leading

       

      Sub Summary Jurisdiction (either Federal or State). % of this service code Total Services

       

      Sub Summary Service code trailing % of Total Total Services

       

      Trailing Grand Summary % of Total Total Services

       

      For each Subsummary Juristiction I would like % of this service code to show what percentage of the total services for that service code each Jurisdiction represents. .

       

      eg, Service code 1 has 100 services

      Federal = 40

      State = 60

      I want the Sub Summary Jurisdiction Federal to show 40%

      Sub Summary JurisdictionState to show 60%

       

       

      How do I calculate the field % of this service code?

       

      Thanks for your help on this.

       

      Jim Brear