Creating a pivot table

[crowegreg]

I'm having difficulty learning a pivot table. Here's what I have.

Query with the following fields:
Acct_Unit - numeric
Report_Category - text
Account_Category - numeric
SumOfTran_Amount - currency



When creating the pivot table, I'm placing the "Acct_Unit" in "Drop Row fields here." The Acct_Unit is displayed as I need it. I place the "Report_Category" in "Drop totals or detail fields here." The Report_Category is displayed as I need it. I place the "Account_Category" in "Drop totals or detail fields here." The Account_Category is displayed as I need it. I place the "SumofTran_Amount" in "Drop totals or detail fields here." The SumofTran_Amount is displayed as I need it.

How do I get the "Total" for each "Acct_Unit"? The title "Total" is displayed under the last "Report_Category" within each "Acct_Unit."

Thanks for your assistance!!

[crowegreg]

I figured it out. When I was adding "SumofTran_Amount," I was not selecting this as data.