9 Replies Latest reply: Feb 25, 2013 10:13 AM by Eduardo Correa da Silva RSS

    Need help aggregating SUM

      Hi-

       

      I was hoping to find the best solution to  aggregate/display values based on user selections. I am working with Reporting Tree (account hierarchy) function.

       

      1. When user picks top level nod (2222222), values on the pivot table do not aggregate but instead report displays lines that roll under selected parent node.

       

      My results look like this:

      ------56                       - 250   

      ------77                       - 250   

       

      Where i would it to look like this

      ---22222               - 500

       

      2. At the moment if user selects base level account, i get accurate values/# of lines. I would like to keep this option as well.

       

      Report strucutre:

       

      Reporting Tree      Amount Sum(Amount)

      11111                      $1000 

      ---22222                   - 500

      ------56                       - 250   

      ------77                       - 250                   

      ---33333                   - 500

      ------78                      - 250

      ------99                      - 250

       

      Please let help.

       

      thanks