Pivot Table Sub Total

[#1]

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!

	Month	Jan	Jan	Feb	Feb
Line	Scenario	A	F	A	F
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.