4 Replies Latest reply on Jan 8, 2013 5:31 PM by Bibhu Chaudhury

    how to add calculations to a subtotal row?

    Bibhu Chaudhury

      I would like to add subtotals to my report which contains some calculated percentages, but doesn't seem to work. The "type X user%' column should be calculated instead of being a sum for the partition...so my logic should be

      IF sub total row flag = Y then use regular calculation [Type X User %] instead of WINDOW_Sum([Type X User %]). Then the values in red below would be 770/1700, 80/150 instead of the >100% values currently shown. I am not sure how to implement this - any help is greatly appreciated.

       

      RegionCountryType X UsersTotal UsersType X User%
      EuropeGermany7060012%
      France40050080%
      Ireland30060050%
      Total7701700142%
      AsiaChina105020%
      Japan205040%
      Singapore5050100%
      Total80150160%

       

      Thanks!

      Bibhu