Pivot Table (Set Values as Column Field)

General purpose: I have categories like Assets, Liabilities, etc. and I want the sum of it in pivot tables.

Please Login or Register  to view this content.

On a regular pivot table, the column field would be Values (the sum of the categories), the row field would be the Account Category (Assets, Liabilities, etc.), and the Values field would be the description (Sum of Foreign Currency and Sum of USD). The Column Field is automatically filled in with "Values" when I'm doing a manual pivot table.

NOTE: I EDITED THE CODE AFTER RESOLVING ONE PROBLEM, BUT STILL NEED HELP WITH THE PROBLEM IN THE TITLE OF THIS THREAD.

PROBLEM: The code above works now but the "Values" is put under "Rows" automatically instead of "Columns." How should I proceed?

Also, how should I add the pivot table on a new sheet? I have this following code currently:

Please Login or Register  to view this content.