0 Replies Latest reply: Dec 14, 2010 2:59 PM by Michael Sherwood RSS

    Pivot Table Sub Total

      I have done this already in excel but I am in the process of trying to replicate this process in QV. I think I would use the aggregation command but I am not certain on this. The bottom two lines are NOT included in the data but they need to be included in the pivot(calculated dimension maybe?)

      It goes like this .. sum(trust income ....other fee income) = total other income

      Sum(total NII, Total other income ) = Total Revenue

      I have this data linked in access using the following field names

       

      Year
      Scenario
      Month
      Business Unit
      Line
      amount


      Any ideas appreciated!

       

      MonthJanJanFebFeb
      LineScenarioAFAF
      Total NII$40,437.$43,998.$37,057.$39,381.
      Trust Income$10,144.$21,554.$6,893.$14,893.
      Service Charges$5,284.$5,723.$4,560.$4,766.
      Total Mtg Banking$19.$20.$11.$11.
      Brokerage Fees$22.$48.$33.$71.
      Loan Fees$6,275.$6,646.$4,437.$4,771.
      Merchant & Credit Card$2,164.$2,363.$1,895.$1,954.
      Other Fee Income$4,231.$8,163.$3,948.$6,391.
      Total Other Income$28,138.$44,517.$21,778.$32,857.
      Total Revenue$68,575.$88,515.$58,835.$72,238.