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

    Subsummary Help needed


      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